Data Witches
  • ABOUT
    • About the Witches
    • Come Find Us
  • SERVICES
  • OUR SPELLS
    • Power BI Licensing Calculator
  • BLOG
  • CONTACT

BLOG

  • Power BI Field Finder

    November 17, 2020

    |

    Data Modeling, Power BI
    Power BI Field Finder

    Have you ever wanted to know where a column or measure is actually being used in Power BI report visuals? Find out easily with the Power BI Field Finder!

    read more

    Read More: Power BI Field Finder
  • My favorite clean and simple way to combine csv files in Power BI

    October 27, 2020

    |

    Data Modeling, How To, Power BI, Power Query

    One of the unsung heroes to me in Power BI desktop (or Power Query in Excel) is how wonderfully simple it is to combine csv or Excel files from a folder. Maybe it’s not totally unsung, but I think it’s an everyday problem that many people have to deal with. It could easily be an […]

    read more

    Read More: My favorite clean and simple way to combine csv files in Power BI
  • Collect/Analyze/Automate with the Power Platform

    October 26, 2020

    |

    How To, Power Platform

    Stephanie and I are data people. We excel at taking loads of unstructured data and making it intelligible (see what I did there?!). Do we want to be working with unstructured data? Is Excel a data collection tool? Or better yet, is Excel a database? In theory the answer to all of these questions is […]

    read more

    Read More: Collect/Analyze/Automate with the Power Platform
  • Create an Interactive Legend in your Power BI Map

    October 24, 2020

    |

    How To, Mapping, Power BI

    Mapping in Power BI can be super simple. Drop a field with a location in it, add a value, and you’re off to the races. Mapping in Power BI can also be challenging, and sometimes it takes a bit of trial and error to get a map close to what you want/need. This post is […]

    read more

    Read More: Create an Interactive Legend in your Power BI Map
  • Adding a row rank based on a different column with Power Query

    October 21, 2020

    |

    Data Modeling, How To, Power BI, Power Query

    Suppose you have two columns of data, one is something to group on and the other is something you could use to rank the rows. It might look something like this (grouping on Person, ranking based on Event Date): Now let’s say that you’d like to use Power Query to add a column that ranks […]

    read more

    Read More: Adding a row rank based on a different column with Power Query
  • Using a Power BI perspective with Analyze in Excel

    October 21, 2020

    |

    Excel, How To, Power BI

    As of August 2020, perspectives can be used by your users when they are working with personalized visuals. Another place you may want to make use of the perspectives you define, though, is in Analyze in Excel.

    read more

    Read More: Using a Power BI perspective with Analyze in Excel
←Previous
1 2

Recent Posts

  • Mirroring Snowflake in Microsoft Fabric 101 – making the connection
  • Radar Chart Fun with SVGs – aka No Small Multiples No Problem!
  • Power BI Field Finder – new and improved!
  • Power BI Licensing Calculator
  • Power BI Accessibility Checker

Categories

  • Accessibility
  • CI/CD
  • Data Engineering
  • Data Modeling
  • DataViz
  • DAX
  • Excel
  • How To
  • Mapping
  • Microsoft Fabric
  • Microsoft Word
  • Power BI
  • Power Platform
  • Power Query
  • PowerPoint
  • Snowflake
  • SVG Images

Contact

[email protected]

All Rights Reserved © Data Witches 2025

Site by JULIA SHARP