Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How can I make a box like the example below with each year from my data serie? I want to visualize the data for the year that is selected and do not want to visualize for the year that isnt
Ex:
Chart:
Data:
Thanks!
@TheUnknown First you need to reshape your data, pivoted data is not a good format for BI. Here is what you can do to unpivot it:
Transform Data -> Select all columns except year columns -> Right click -> Unpivot other columns
It will create two columns called Attribute and Value, rename as you see fit, attribute will contain year column, close and apply.
Now you can use the month column on the x-axis and value on values and year as a legend and that will do it.
As a best practice, add a date dimension in your model and use it for time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools. Check the related videos on my YT channel
Add Date Dimension
Importance of Date Dimension
Mark date dimension as a date table - why and how?
Time Intelligence Playlist
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |