Forum Discussion

smiller's avatar
smiller
Frequent Visitor
2 years ago

Show hide columns based on a slicer

HI, I have a table set up that has client name id and population and client status. I want to be able to pick what columns are displayed based on a slicer so for example. When Open client is picked in the slicer, it shows id and client name and population, but when Closed is chosen, I just want Name and population to show. Is this possible ? I tried with field a parameters, but its like I need to group the fields or something.

Need Help

2 Replies

  • Alex87's avatar
    Alex87
    Icon for Solution Sage rankSolution Sage
    2 years ago

    it is possible with field parameters. Please provide sample data in order to prototype the solution

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, smiller 

    I create a table:

     

    Create a measure that returns a field value or a blank value based on the slicer selection, rather than using the field directly. For example:

    Display Client ID = 
VAR _ID = CALCULATE(MIN('Table'[ID]))
 RETURN
IF(SELECTEDVALUE('Table'[status]) = "Open", _ID, BLANK())

    Make sure that the slicer is correctly set up to filter based on status. This slicer will control which measures return values and which return blank values, effectively showing/hiding columns.

     

    How to Get Your Question Answered Quickly 

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)

    Best Regards

    Yongkang Hua

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.