Forum Discussion

Kharabela's avatar
Kharabela
Helper I
9 years ago

Filter on Measurable Objects..

Dear Friends,     Is it possible to apply filter on measurable objects. In the attached picture the encircled are measures. Can I make there visibility dynamically i.e. based on user choice a...
Reports
v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

Kharabela

 

We cannot use slicer to make them display dynamically. But there is an alternative, if the measure is selected in the slicer, then it will show value in Table or Matrix visual, if the measure is not selected in the slicer, then blank value will be shown in Table or Matrix visual.

 

Please refer to my attached PBIX file as sample. I create Table2 which contains the names of three measure, and adjust the measure formulas as below. So that when the measure is selected, it will return the calculate result, if it is not selected, it will return blank.

 

P 2017/4 = 
IF (
    SEARCH ( "P 2017/4", [SelectedItems],, -1 ) > 0,
    CALCULATE ( SUM ( Table1[Sales] ), MONTH ( Table1[Date] ) = 4 )
)

 

 

Best Regards,

Herbert