Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a report page with a Year-Month slicer. I want my column chart of to automatically show the same months previous years on x axis. For example, when 2018-05 is selected from my slicer, the chart would rearrange to show 2016-05,2017-05 and 2018-05 on its axis. Right now my chart only displays the selected year-month. I hope my question makes sense. Any help or tip would be much appreciated!!
Hi hyeeun,
You can create a calculate column using DAX formula as below and create a slicer chart based on the new column:
Month Column = MONTH ( Table[Date] )
Then you can use the slicer to filter the chart you have created.
Hope it's helpful to you.
Jimmy Tao
Thanks for your comment Jimmy but I don't think my question was clear.. The month I'm refering to is already in DAX and have a slicer. I am trying to have my column chart to show same month previous years as shown on the image below(on the right) but my slicer is limiting it to only show the value like the image on the left b/c "2018-05" is selected from the filter.
The only way I can get this to work is creating two slicers; one for Month and one for Year and turning off the filter interactivity from the Year slicer to the chart so it only reposponds to Month slicer. This however messes up with another visual I created which is a percent change calculation from the previous month. There must be more sophisticated way of achieving this. Anyone??
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |