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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
eliasayyy
Super User
Super User

Help with Slicers

Hello i have multiple questiosn regarding slicers

first questions is i made field paraemters and it gave me slicers

i added a new column named Type that will divide my emasures into categories like so

annonymous1999_0-1683207496568.png

 

so i added 2 slicers

first is type that is main category 

second is the fields of the parameter aka the measures

when i select a value from the parameter slicer, the main category will only return the category related to the field so for example if i select cost measure , the category slicer will only return me to choose Finance.

i turned off interaction and it solved the issue but it created another issue

annonymous1999_1-1683207620405.png

here i seelcted finance category and cost category 

but when i select engagement for example category, this happens

annonymous1999_2-1683207665594.png

and i have to press any field to get my data back

how can i make it easily switch auatmatically to the fields of performance category instead of having to click 

2) my second question is can i hide a visaul if i select a value from a slicer ?


@tamerj1 @FreemanZ @amitchandak 




1 REPLY 1
lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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

Top Kudoed Authors