Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a calculation group that is set to:
SELECTEDMEASURE()
with a format string of:
IF ( SELECTEDVALUE ( 'MSR_EMEAMeasures'[Currency] ), SELECTEDVALUE ( 'Dimension Currency'[Symbol] ), "" ) & SELECTEDVALUE ( 'MSR_EMEAMeasures'[PBIFormat] )
When I interact (click a bar) with the Chart the Matrix inherits the format string of the Chart, is there any way of preventing this?
It should look like this (formatted correctly):
Note:
Both the Matrix and the Chart reference separate tables with the same list of KPIs:
Hi @JohnShepherdAPD ,
Please share some sample data so that we could test formula.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |