Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
DPE_Fabulous
Frequent Visitor

Ignoring the interaction of a slicer but keeping the value of the slicer

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.

 

DPE_Fabulous_0-1689852344080.png

 

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 🙂

2 REPLIES 2
DPE_Fabulous
Frequent Visitor

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.

v-stephen-msft
Community Support
Community Support

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.           

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.