cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HamidBee
Post Prodigy
Post Prodigy

Percentages not plotting properly on Charticulator

Hi All,

 

I am trying to plot a table in a chart I c reated on Charticulator but the issue I'm having is that it's plotting the numbers divided by 100. Please see below:

 

Percentage.png

Any suggestions on how I can fix this. Thanks.

1 ACCEPTED SOLUTION
HamidBee
Post Prodigy
Post Prodigy

Solved. I went to tick format and typed the following:

{.0%}

Further reading can be found here:

 

https://charticulator.com/docs/user-interaction.html#text-formatting

View solution in original post

3 REPLIES 3
Burningsuit
Super User
Super User

Hey @HamidBee 

It must be Charticulator day today, we've worked with it for months and not seen many questions here, now there's two in a day 😁

 

The issue here is between Data and Format. The column you're sending to Charticulator is formatted as a Percentage. That effectivly formats the underlying data by multiplying it by 100 and adding a % sign when it is displayed. Beyond the formatting the number is "24" but formatting as a percentage shows the number as "2400.00%". When you send the data values to Charticulator it sees the data but not the formatting, so it sees "24" etc. and graphs that. 

To see the same values in both PowerBI and charticulator you can..

A) remove the formatting from the Precentage column or measure (In either Column or Measure tools set the format to "Decimal Number" rather than "Percentage". Or...

B) Create a  value multiplied by 100 for Charticulator to use. If you're using a Column this would be simply ChartCol=MyColumn] * 100 as a calculated column, if it's a measure it may be more complex depending on the measure and the filter context, but you can try ChartNo=SUM[MyMeasure] * 100.

Either way what you're seeing is formatted data on the report canvas, Charticulator doesn't see that it sees the raw unformatted number.

Hope this helps

Stuart

Hi Stuart,

 

Thank you for your detailed response. It's encouraging to see the wealth of knowledge people have in this forum. I look forward to reading your book someday please keep me posted. I've used Python visuals in BI. I was really impressed with the level of freedom one has on it. But, filters and drill downs just aren't compatible on Python visuals. The fact that they are compatible on Charticulator makes it a grand slam for me. Although they do need to fix their user interface it is prone to glitches. I'm confident that will come with time though. 

I came across another issue, It really is Charticulator day!

https://community.powerbi.com/t5/Service/The-categories-on-the-chart-suddenly-became-disorganised-as...


HamidBee
Post Prodigy
Post Prodigy

Solved. I went to tick format and typed the following:

{.0%}

Further reading can be found here:

 

https://charticulator.com/docs/user-interaction.html#text-formatting

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors