When repositioning the legend in the Charticulator, it should be postioned on the X-Axis & Y-Axis intersection points otherwise it will behave strangely once imported in PBI.
The question is why you are showing the legend when the categories are already distinguished by colors?
Radial charts in PBI move clockwise not anti-clockwise therefore, the negative values are not moving in different direction. However, if you sort the data in descending order, that way you can clearly see your lowest value while radial chart still looks good.
You need to have the answers to the following questions before designing your own visual:
- How the data will be arranged for Charticulator?
- Whether the same arrangement is possible while using the visual in PBI?
For e.g. I had to rearrange the data in the following pattern that is different to your existing PBI structure:
Lastly, you are using the wrong visual to display your analysis. It is equally important to choose the right type of visual for your analysis. You can show Revenue, Cost & profits in Cards as KPI’s or through Line Charts to show trends or through the most popular Bar & Column charts.
Remember that the visual behaves differently in Charticulator and in Power BI.
I hope the explanation helps.
RadialChart.csv (59 Bytes)
management.pbix (3.7 MB)
RadialChart (2).pbiviz (245.6 KB)