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.
I have a matrix, where I have the monthly figures and a running total. For the different categories I would like to show the monthly figures and for the total I would like to show the running total. I am able to "hide" the columns by setting auto-size to off and then dragging the columns. However, when I change the employee I would like to see (slicer) the format changes and the hidden columns are partly visible.
How can I solve this? It doesn't look very nice. The first matrix is correct and the second shows my problem.
Thanks a lot.
Helen
Solved! Go to Solution.
Hi @HEW ,
I created a simply data sample to test:
To my knowledge, since there is no option to dynamically hide fields based on a slicer, you may use Conditional Formatting to keep the font color to make it look like hidden:
change sum color = IF(MAX('ForSlicer'[Value])="sum","Black","White")
change average color = IF(MAX('ForSlicer'[Value])="average","Black","White")
Or create a new table for slicer firstly, and then use SWITCH() to match the measures like:
ForSlicer = {"sum","average"}
Measure = SWITCH(MAX('ForSlicer'[Value]),"sum",[sum],"average",[average])
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @HEW ,
I created a simply data sample to test:
To my knowledge, since there is no option to dynamically hide fields based on a slicer, you may use Conditional Formatting to keep the font color to make it look like hidden:
change sum color = IF(MAX('ForSlicer'[Value])="sum","Black","White")
change average color = IF(MAX('ForSlicer'[Value])="average","Black","White")
Or create a new table for slicer firstly, and then use SWITCH() to match the measures like:
ForSlicer = {"sum","average"}
Measure = SWITCH(MAX('ForSlicer'[Value]),"sum",[sum],"average",[average])
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |