Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
updated with real data and images.
I wanted to use the meter graph to display my data.
In my BBDD, I have a field to define whether it is maximum, minimum, target or actual data.
the id is heatid,the data is elementary,the category is chemistrytypecode
take quick action on the field but from what I see it makes me sum all the data, for example:
elemental para 10 =
CALCULATE(
SUM('ramses vista_analisisentradaHC'[elemental]),
'ramses vista_analisisentradaHC'[chemistrytypecode] IN { 10 }
)
the result of this is that the measurements are not being filtered by the ID, but by displaying all the data.
how should I do this?
Thank you
Hi @vhailor ,
Is this the problem?
Unless using hierarchical slicer.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @vhailor ,
Will the ‘Chart Name’ label aggregate your [ID] column?
What are the fields in each of the labels? Can you provide a screenshot of the report?
Or create a measure liek this?
__ID = SELECTEDVALUE(Sheet2[ID])
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@vhailor I am not following this, can you try explaining in greater detail what you are trying to accomplish?
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |