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.
Hello Community,
Question was asked here,
https://community.powerbi.com/t5/Desktop/How-to-show-set-slicer-to-current-month/td-p/83302
If I publish in July, my month slicer will only show Jan through July at the time of the publish. I choose July in my slicer, publish, and that is what is in the service. In August, July is still the selected slicer option, so the visuals are based on last month, not this month. Only fix is to open the desktop, refresh, choose new month, republish.
Can any one has any suggestion?
Thanks
Solved! Go to Solution.
@tejapowerbi123 , Create a column like this in your date table and select this month. It will make sure it always this month
Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)
Sort it on
Format([Date],"YYYYMM")
@tejapowerbi123 , Create a column like this in your date table and select this month. It will make sure it always this month
Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,
eomonth([Date],0)= eomonth(Today(),0),"This Month" ,
Format([Date],"MMM-YYYY")
)
Sort it on
Format([Date],"YYYYMM")
Hi Amit,
Thank you so much for your suggestion.
User does not wants to see "Current Month" as a selection that's the issue.Otherwise solutions is working perfectly fine.
Thanks
@tejapowerbi123 - Hmm, general solution to something like this is to create a column in the dataset that has a value of 1 for the current month and 0 otherwise. You can then filter/slice on 1. But, this isn't the most user friendly.
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 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |