Forum Discussion
Avoid Aggregation for Gauge
Hi pbiuser0000
For Gauge visual , you can only put fields with Whole number type in it . In Target value , the value for field is impossible to display classified .So when you put field “Level Required” in Target value , the displayed data is not your actual data in the master table, but aggregated calculations .
My suggestion is adding a slicer with “Skill”from master table. And choose sum for “Level Required” in Target value .
I have attached my pbix file ,you can refer to it .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi pbiuser0000
For Gauge visual , you can only put fields with Whole number type in it . In Target value , the value for field is impossible to display classified .So when you put field “Level Required” in Target value , the displayed data is not your actual data in the master table, but aggregated calculations .
My suggestion is adding a slicer with “Skill”from master table. And choose sum for “Level Required” in Target value .
I have attached my pbix file ,you can refer to it .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous,
Thank you a lot for your help.
I could apply and get the good result with my file.
But at first, I couldn't get the same result as yours because I used in the slicer the "Skill" from the fact table and show me the sum of the whole master data. But the one from the master data shows me the right result.
Do you have any recommandation on how to use a common field between a fact and a master data ?
I don't remind observe this behaviour in other data viz tool (Qlik, Tableau...)
Best regards,
