Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi. I am using a calendar tables and i cant hide the futes dates in the slicers and graphs
Solved! Go to Solution.
Hi @Asanchez11 ,
I suggest you to create a measure to filter your visual.
Filter = IF(MAX('Calendar'[Date])<=TODAY(),1,0)
I can reproduce your issue when my calendar table contains future date.
Add above measure into visual level filter and set it to show items when value = 1.
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Asanchez11 ,
I suggest you to create a measure to filter your visual.
Filter = IF(MAX('Calendar'[Date])<=TODAY(),1,0)
I can reproduce your issue when my calendar table contains future date.
Add above measure into visual level filter and set it to show items when value = 1.
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
As soon as you add measures based on fact tables these will disappear (unless you have facts in the future)
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
187 | |
94 | |
67 | |
63 | |
54 |