Forum Discussion

marslnn's avatar
marslnn
New Member
4 years ago
Solved

Hiding column based on selection in table/matrix

Hi,

 

I have slicer which has some kpi's in it. Lets say i have kpiA, kpiB and kpiC on slicer. When i select kpiC on my slicer, i want YTD column on my table/matrix to be hidden. Is there a way to achieve this simple requirement in PowerBI?

 

Thanks in advance.

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi marslnn ,

     

    You could create a measure as a visual level filter.

    Measure = IF(SELECTEDVALUE('Table'[kpi])="kpiC",1)

    Then put the measure into the Filters on the visual. Set show items when the value is not 1.

     

    Result:

     

     

     

    Best Regards,

    Stephen Tao

     

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

     

     

2 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    4 years ago

    Hey marslnn ,

     

    can you post an example file?

    In Power BI it depends so much on the data model. Otherwise I can just assume and propose some approaches that might not work for you.

     

    But in general hat is possible.

     

    Best regards

    Denis

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi marslnn ,

     

    You could create a measure as a visual level filter.

    Measure = IF(SELECTEDVALUE('Table'[kpi])="kpiC",1)

    Then put the measure into the Filters on the visual. Set show items when the value is not 1.

     

    Result:

     

     

     

    Best Regards,

    Stephen Tao

     

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