Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Good, I'm trying to show the data from a table in a pie chart and in the table I have some results where the number is negative, and in the graph I'm just taking the positive values, the negative results don't show them.
I would like to show both positive and negative values on the chart.
Greetings, thank you.
Solved! Go to Solution.
If you have some negative values a pie chart might not be the best option.
You could use ABS() to get the absolute value, which a pie chart would plot, but then you'd need a way to show which are negative or not (SIGN() could help with that). Or, you could have two pie charts, one for the positive and one for the negatives?
Hi @Syndicate_Admin ,
Agree with the comments given by @AntonioM . What is your specific business scenario and can you provide more detailed information, maybe I can give you the best reference.
Looking forward to your reply.
Best Regards,
Henry
If you have some negative values a pie chart might not be the best option.
You could use ABS() to get the absolute value, which a pie chart would plot, but then you'd need a way to show which are negative or not (SIGN() could help with that). Or, you could have two pie charts, one for the positive and one for the negatives?
User | Count |
---|---|
77 | |
74 | |
60 | |
60 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |