Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
I need a filter where I can select the filter like previous month but it should work for this year as well as for last year.
For example if I have data for this year and last year and I want to show the count of tickets brocken by priority for previous month ( April-2020 and April 2021) then how to create such filter.
Can someone please help me.
Solved! Go to Solution.
@Ramendra Hi Ram, in this case i would suggest you to create seperate measure to calculate value for previous year. So when you select April month, it will show the data for both previous year and current year
Proud to be a Super User!
@Ramendra Hi Ram, in this case i would suggest you to create seperate measure to calculate value for previous year. So when you select April month, it will show the data for both previous year and current year
Proud to be a Super User!
@Ramendra , Create two measures
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))
if you want to switch, you can use measure slicer
measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
User | Count |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
112 | |
96 | |
94 | |
64 | |
58 |