Visualization ideas for categories with big differences

[Anonymous]

Hello world , newbie to powerbi here, 
i have 3 years, with 3 categories in total and I want to visualize the whole thing, but the tremendous difference among those categories doesn't help me to make a better (at least in my mind) visualization of such data. Check the printscreen. Any better ideas/best practices for such cases?? 

Thanks everyone.!

[amitchandak · Accepted solution]

In line chart you have option Scale Type = Log. You can try that , there will be three lines, but near to each other

[Anonymous]

The idea of log axis is amazing, as starting the axis from a different point creates the danger of creating misunderstandings. Choosing both log axis+clustered column chart creates a really good visualization. The line graph seems very strange despite it seemed like an intuitive solution.

[v-diye-msft · Accepted solution]

Hi @Anonymous 

what about the clustered column chart?

Or you might change the display of Y-xis and start from 80%, 85%,90%,95%...

like below:

Actually AFAIK, there's no method to fix it, if the above not helps, you could probably raise it as an idea here:

https://ideas.powerbi.com/forums/265200-power-bi-ideas 

[amitchandak · Accepted solution]

In line chart you have option Scale Type = Log. You can try that , there will be three lines, but near to each other