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 added a measure to my matrix table which calculates the percentage difference between the actual and the targeted amounts. Only issue is that this calculated value repeats against the actual and the target amounts - as per below.
I do not want this value to show against the Actual Amount (as highlighted) but only against the Target amount. For example, I'd like the Jul-19 first 2 rows to look like:
$0.03M $0.02M 50.1%
$0.16M $0.06M 150.5%
Is there a way that I can hide/remove the columns highlighted below? Thanks, Frank
Solved! Go to Solution.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsRegards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsI ran into this situation today.
For all the columns you want to hide, it's overlapping with a column which a context in the column. You can exclude those by using the following
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |