cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cobra77 Member
Member

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

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

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

@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.
4 REPLIES 4
Moderator v-yuezhe-msft
Moderator

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

@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.
Cobra77 Member
Member

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

Thanks for your answer lydia.

 

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

Moderator v-yuezhe-msft
Moderator

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

@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.
Cobra77 Member
Member

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

Its ok ;-)

Thanks Lydia.