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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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