Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Visualization ideas for categories with big differences

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.!

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

3 Replies

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

  • v-diye-msft's avatar
    v-diye-msft
    Community Support

    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 

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.