Hello (New here)
I am new to using power BI and am having some trouble with my data formatting.
Example of current data set
Currently when Import the data into power BI it looks like this (photo below)
I would like to make it so when I make a graph and slicer I can select a year and a month in that year and it will display the total and which category that total is from.
Example (group Jan Feb ECT from 06 into '2006')
been trying for a few days and am looking for some help.
If I understand your request, I think the first step you need to do is unpivot your columns to go from a view like this:
to this:
then you can rename the Attibute column as Month and use it as a filter. Also from there you add columns or format the Month column to fit the date structure you need.
Hope this helps!
If I understand your request, I think the first step you need to do is unpivot your columns to go from a view like this:
to this:
then you can rename the Attibute column as Month and use it as a filter. Also from there you add columns or format the Month column to fit the date structure you need.
Hope this helps!
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
We want your feedback!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
