Forum Discussion

HSpeelman's avatar
HSpeelman
Frequent Visitor
4 years ago

Show additional measures in same visual based on selected value in the slicer

Hi,

 

I have following case for my client:

 

- Problem:

  1. User wants to select one value in a slicer ('net sales' or 'costs')
    1. When 'net sales' is selected, a table needs to be shown with 4 columns: 'category', 'net sales', 'previous year net sales', 'net sales budget'
    2. When 'costs' is selected, a table needs to be shown with 3 columns: 'category', 'costs', 'previous year costs'

I am not sure if it is possible to have this kind of mechanic in Power BI.

 

I currently fixed it with having a visual filter on two separate visuals, where DAX detects which value is selected in the slicer and based on that, the visual A or B is shown. However, this implies that two visuals need to be maintained and tooltips won't work for one of the visuals as they are placed on top of each other.

 

So I wanted to check if it is possible to have this kind of mechanic in one visual.