Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 any field can be displayed.
Regards.
KP
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
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
97 | |
97 | |
73 | |
72 |