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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Naveennegi119
Helper III
Helper III

Hide values in selected by slicer

Hi All,

 

 

I'm stuck on a problem and can't figure out.

data for referance is below:-

CategorySub-CategoryC+Sub-Cat.ValueIndex
ATAT1501
ATAT1462
ATAT1453
ATAT1214
ATAT1145
AVAV1421
AVAV1422
AVAV1103
AVAV1044
AXAX1411
AXAX1232
AXAX1203
AXAX1054
AXAX1005
AZAZ1481
AZAZ1262
AZAZ1193
AZAZ1024
BSBS1471
BSBS1412
BSBS1343
BSBS1134
BSBS1045
BSBS1016
BUBU1391
BUBU1252
BUBU1193
BUBU1174
BUBU1075
BWBW1481
BWBW1482
BWBW1283
BWBW1254
BWBW1225
BWBW1226
BYBY1221
BYBY1132
BYBY1103
BYBY1044
BYBY1025

value hide by slicer.JPG

 

Hope everyone understand what i'm saying in image.

 

Regards,

 

1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

Hi @Naveennegi119

while in Power BI desktop, it is not possible to dynamically show/hide value or visual, one workaround is to to show blank for the value you want to hide.

I make a test and work out these results

“If I select category slicer then hide the value of sub-category”

64.png

“If I select sub-category slicer then hide the value of category”

 65.png

Does these above meet your needs?

If so, create measures like this

MAX OF CATEGORY =
IF (
    HASONEVALUE ( Table1[Sub-Category] ),
    BLANK (),
    CALCULATE ( MAX ( Table1[Value] ), ALLSELECTED ( Table1[Category] ) )
)
MAX1 OF SUBCATEGORY =
IF (
    CALCULATE (
        HASONEVALUE ( Table1[Category] ),
        ALLEXCEPT ( Table1, Table1[Category] )
    ),
    BLANK (),
    CALCULATE ( MAX ( Table1[Value] ), ALLSELECTED ( Table1[Sub-Category] ) )
)

 

 

Best Regards

Maggie

 

View solution in original post

3 REPLIES 3
v-juanli-msft
Community Support
Community Support

Hi @Naveennegi119

while in Power BI desktop, it is not possible to dynamically show/hide value or visual, one workaround is to to show blank for the value you want to hide.

I make a test and work out these results

“If I select category slicer then hide the value of sub-category”

64.png

“If I select sub-category slicer then hide the value of category”

 65.png

Does these above meet your needs?

If so, create measures like this

MAX OF CATEGORY =
IF (
    HASONEVALUE ( Table1[Sub-Category] ),
    BLANK (),
    CALCULATE ( MAX ( Table1[Value] ), ALLSELECTED ( Table1[Category] ) )
)
MAX1 OF SUBCATEGORY =
IF (
    CALCULATE (
        HASONEVALUE ( Table1[Category] ),
        ALLEXCEPT ( Table1, Table1[Category] )
    ),
    BLANK (),
    CALCULATE ( MAX ( Table1[Value] ), ALLSELECTED ( Table1[Sub-Category] ) )
)

 

 

Best Regards

Maggie

 

Hi @v-juanli-msft,

 

it's almost look-like what i want.

 

thanks for sharing your idea.

 

Regards,

NICK

Hi @v-juanli-msft,

 

I have a doubt.

 

Can we show blank if both slicer not selected.

 

Regards,

NICK

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors
Top Kudoed Authors