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.
Can you guys suggest me on???
The Parameter Selection option for the users showing
1. Current Month
2. Previous Month
selections, as data filtering on the dashboard Charts.
like Net sales, Budget sales,.. data for current or previous months on selection
Solved! Go to Solution.
Probably the easiest way to do this is by modify your Calendar table to have a calc column where rows that in the current month are labeled "Current Month" and rows in the prior month are labeled "Previous Month", and others are labeled something like "Older".
If you then put that on a slicer... you will have { Current, Previous, Older } and when nothing is selected... you will get all data.
Hi @ShashidharG,
I agree with scottsen's point of view, I share the sample formula, perhaps you can refer to it:
Check Date= if([Date].[Year]=YEAR(TODAY()),SWITCH([Date].[MonthNo],MONTH(TODAY()),"Current Month",MONTH(TODAY())-1,"Previous Month","Other"),"Other")
Regards,
Xiaoxin Sheng
Hi @ShashidharG,
I agree with scottsen's point of view, I share the sample formula, perhaps you can refer to it:
Check Date= if([Date].[Year]=YEAR(TODAY()),SWITCH([Date].[MonthNo],MONTH(TODAY()),"Current Month",MONTH(TODAY())-1,"Previous Month","Other"),"Other")
Regards,
Xiaoxin Sheng
Probably the easiest way to do this is by modify your Calendar table to have a calc column where rows that in the current month are labeled "Current Month" and rows in the prior month are labeled "Previous Month", and others are labeled something like "Older".
If you then put that on a slicer... you will have { Current, Previous, Older } and when nothing is selected... you will get all data.
Thanks @Anonymous and @v-shex-msft 🙂 ..That's two best approaches and worked !!!
tried with slicer using-
TimePeriod = IF(MONTH(SalesHist[BillDate])=MONTH(TODAY()) && YEAR(SalesHist[BillDate])=YEAR(TODAY()) , "CurrentMonth", IF(MONTH(SalesHist[BillDate])=(MONTH(TODAY())-1) && YEAR(SalesHist[BillDate])=YEAR(TODAY()), "PreviousMonth","Older" ) )
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |