Hide values in selected by slicer

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”

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

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