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.
Hello,
I hope you are well?
I'd like to create a visual displaying the last 7 months according to the slicer date, without any interaction between the slicer and the visual (Digits 1 and 2). So here, i'm filtering with the Digits 2 my table (measure = 1). If I change the slicer value, it doesn't affect my measure.
In fact, I'd like to keep the value of the slicer (red number 1) in order to put it into a calculation used to filter dates (green number 2). I'm currently using the LASTEDATE value as _MaxDate, but when I deactivate the slicer, the LASTDATE no longer corresponds to it.
Can you help me? Thank you 🙂
Hi @v-stephen-msft ,
I'm already using a separate calendar table because I use a lot of separate datasources. I use my Calendar Table as a slicer to filter some measures.
I've already thought about this solution but it doesn't work at all.
Hi @DPE_Fabulous ,
It sounds like you can create a separate calendar table, and then the slicer's dates come from this table. Because this table is independent, it is not affected by others. You can use SELECTEDVALUE function.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
136 | |
73 | |
72 | |
56 | |
55 |
User | Count |
---|---|
199 | |
95 | |
63 | |
62 | |
51 |