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

Slicer Selections

Hello Everyone,

    Not sure about this, Is it possible to apply visual level filter to a slicer visual...?

 For example my sclier has month column and I would like to have only few months like Jan,Mar,Apr,May,Dec. Can I use visual level filter over here or do any other things.

 

Thank You

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Slicer Selections

@pxg08680 I think you have two options here:

 

Option 1 ->  Create two new calculated table and use slicer from there.

Option 2 -> Add two new calculated field in your table like below but this will give one blank row for each slicer

 

 

Slicer 1 = if(Table1[Range]="3M AVG", Table1[Range], "")

Slicer 2 = if(Table1[Range]<>"3M AVG", Table1[Range], "")

 






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





4 REPLIES 4
Moderator v-yuezhe-msft
Moderator

Re: Slicer Selections

@pxg08680

It is not possible to use visual level filter to a slicer, instead, you can use page level filter. Or you can directly select the months you need in the slicer.
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.
pxg08680 Member
Member

Re: Slicer Selections

@v-yuezhe-msft

Thanks for the reply. Let me give some more info.

 

I have a column called Period and I am using this in my slicer. My slicer looks like this

a1.PNG

What I need is, I want to pull out the 3M Avg from the slicer and use it as a separate slicer.

My 1st slicer should show me 

--Select a Value

Current

Last 1 Month

Last 3 Month

Last 6 Month

Last 12 Month

 

and my new slicer should have

3M Avg

 

 

 

Super User
Super User

Re: Slicer Selections

@pxg08680 I think you have two options here:

 

Option 1 ->  Create two new calculated table and use slicer from there.

Option 2 -> Add two new calculated field in your table like below but this will give one blank row for each slicer

 

 

Slicer 1 = if(Table1[Range]="3M AVG", Table1[Range], "")

Slicer 2 = if(Table1[Range]<>"3M AVG", Table1[Range], "")

 






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





pxg08680 Member
Member

Re: Slicer Selections

@parry2k

I think creating a new table is better rather than having blank selection.

 

Thank you

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 39 members 1,028 guests
Please welcome our newest community members: