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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Cobra77
Post Patron
Post Patron

Filter a date , but not on the graphs , with a single calendar table ?

Hi ,

 

With Power Bi on SSAS Tabular , live , It s possible to filter a date , with the date filed , but no filter the graphs ? without adding  another date table

 

Sample :

Filter : 30-09-2017

 

and thats the graphs ( like stacked column chart ) goes from January to September 30 , with the date field ?

 

Thanks for your help.

 

1 ACCEPTED SOLUTION

@Cobra77

You are able to use other filters to filter the graph, only when you select values in the Date slicer, the graph will not be affected.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-yuezhe-msft
Employee
Employee

@Cobra77,

Based on your description, it seems that you don’t want to apply date filter on the graphs, right? If so, you can use “Edit interactions” feature in Power BI Desktop.

Create a date slicer, click on the date slicer, then turn on “Edit interactions” under Format ribbon, select “None” in the stacked column chart.  This way, when you select values in the date slicer, the chart will not be filtered.
1.JPG


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for your answer lydia.

 

But if i have others filters ? i lose interaction with ?

@Cobra77

You are able to use other filters to filter the graph, only when you select values in the Date slicer, the graph will not be affected.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Its ok 😉

Thanks Lydia.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.