Print the selected value on the dashboard

[psonawane]

Hi, I have a slicer with 4 dimensions such as Status (Values: New, Dismissed,etc) , Department(Values: Technology, Compensation, etc) , Policy(Values: PII, PCI) and Severity(Values: High, Medium, Low). If we select Status a bar char gives Incident Count by Status, if we change the slicer to Department, the same bar chart would show Incident Count by Department.

Now if we have Incident Count by Status and we click on "New" Status bar, there should be text stating 'Status: New'. If we have change the slicer to show Incident Count by Policy and we click on "PII" Policy bar, there should be text stating 'Policy: PII'.

Can you please help me with a DAX code. I have one which prints only for one dimension, it does not change if we change the slicer.

Here: SlicerTable has all the Dimension Values.

SelectedVal1 = IF(ISFILTERED(SlicerTable[type]),

IF( ISBLANK(

CONCATENATEX (

VALUES ( incidents[Name of Policy] ),

incidents[Name of Policy],

", "

)), BLANK()," Policy: " &

CONCATENATEX (

VALUES ( incidents[Name of Policy] ),

incidents[Name of Policy],

", "

)))

[amitchandak]

@psonawane , are you looking for Once Slicer for multiple columns ?
https://community.powerbi.com/t5/Desktop/Once-Slicer-for-multiple-columns/td-p/407949

[psonawane]

@amitchandak That is excatly what I did, now if I select one column from the slicer and click on any bar of the barchart, I want to display what I clicked on the dashboard. And it should reset and change if I select a value from another column from the bar chartIn this I have Policy as my column and I clicked on PCI, hence it is showing that I clicked on Policy:PCI.Now I have Department as my column from the slicer and I clicked on Engineering, but it still shows values for the Policies. I want to show Department: Engineering