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.
Go to Solution.
@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], "")
Proud to be a Datanaut! Appreciate your Kudos Feel free to email me with any of your BI needs.
@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. Regards, Lydia
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
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
Last 1 Month
Last 3 Month
Last 6 Month
Last 12 Month
and my new slicer should have
I think creating a new table is better rather than having blank selection.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.