Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |