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.
Hi! I'm trying to create a report with two tables, one is Companies and the other is Specialities, I can create a pie chart for each company with every speciality and all but when I connect them it stops working and throws this error: Negative values aren't supported and are being displayed as absolute values BUT NO NEGATIVE VALUES
You were able to solve it, I have the same case
Hi @rolopezteteruk ,
The final chart you need is pie chart with negative number. Take the absolute value of the column to display in the pie chart.
You can create a measure as below and use it in the chart.
Measure = ABS ( SUM ( 'Table'[values] ) )
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
I try with linebars and table and it doesn't show any data either
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |