Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, quick question, I have a solution that allows my report users to add/remove the display of measure data in a Matrix visual. However, as you can see, the solution is not ideal.
Is there a way to add/remove the measure itself and not just the data?
Thanx in advance.
Solved! Go to Solution.
Hi, @pawlowski6132
After the test, I can just use measures to achieve the dynamic display of measures' data based on the Slicer selection, the title can’t disappear because the measures are placed into the value of the Matrix and they won’t disappear until you delete them from the Matrix manually, here are my steps:
I created the measures for the measures I want to slicer by the selection of Slicer:
Measure11 =
var _selectedmeasure=
SELECTCOLUMNS(ALLSELECTED(Slicer),"1",[name])
return
IF("Measure1" in _selectedmeasure,[Measure1],BLANK())
Measure22 =
var _selectedmeasure=
SELECTCOLUMNS(ALLSELECTED(Slicer),"1",[name])
return
IF("Measure2" in _selectedmeasure,[Measure2],BLANK())
Measure33 =
var _selectedmeasure=
SELECTCOLUMNS(ALLSELECTED(Slicer),"1",[name])
return
IF("Measure3" in _selectedmeasure,[Measure3],BLANK())
And I created a Matrix and a Slicer table and place like this:
You can download my test pbix file here
Here are some possible ways to achieve adding/Removing matrix columns based on Slicer, you can check if they can meet your requirement in your situation:
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @pawlowski6132
After the test, I can just use measures to achieve the dynamic display of measures' data based on the Slicer selection, the title can’t disappear because the measures are placed into the value of the Matrix and they won’t disappear until you delete them from the Matrix manually, here are my steps:
I created the measures for the measures I want to slicer by the selection of Slicer:
Measure11 =
var _selectedmeasure=
SELECTCOLUMNS(ALLSELECTED(Slicer),"1",[name])
return
IF("Measure1" in _selectedmeasure,[Measure1],BLANK())
Measure22 =
var _selectedmeasure=
SELECTCOLUMNS(ALLSELECTED(Slicer),"1",[name])
return
IF("Measure2" in _selectedmeasure,[Measure2],BLANK())
Measure33 =
var _selectedmeasure=
SELECTCOLUMNS(ALLSELECTED(Slicer),"1",[name])
return
IF("Measure3" in _selectedmeasure,[Measure3],BLANK())
And I created a Matrix and a Slicer table and place like this:
You can download my test pbix file here
Here are some possible ways to achieve adding/Removing matrix columns based on Slicer, you can check if they can meet your requirement in your situation:
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please look into the functionality of Calculation Groups and SELECTEDMEASURE()
thanx, will do
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |