Forum Discussion

LABORSAL's avatar
LABORSAL
Advocate II
6 years ago

Histogram from a measure table

Hello,   I'm trying to create a histogram to display how the BIAS of a group is behaving.   I created a table through Power Query which can give me the information I need at the highest possible ...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
6 years ago

LABORSAL , I checked out there is no option for tick interval. You can only change the decimal places.

 

You can try few other Histogram option in custom charts

Refer if this can help for any other : https://spreadsheeto.com/power-bi-histogram/

 

 

Please Watch/Like/Share My webinar on Time Intelligence: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
My Youtube Tips at: https://www.youtube.com/playlist?list=PLPaNVDMhUXGYrm5rm6ME6rjzKGSvT9Jmy

Appreciate your Kudos.

LABORSAL's avatar
LABORSAL
Advocate II
6 years ago

Current solution for that (which is what I believe is causing the split of groups) is to add a column to the main table

 

however if I use that column as axis it groups the SKU by bin from main table (which is what I explained in the graphs on original post)

 

I can recreate this column by adding a calculated column which does the same as the BIAS but rounds down to 1 decimal, however I have no idea how to use this calculated column in the measure for the axis.

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi LABORSAL ,

     

    “I can recreate this column by adding a calculated column which does the same as the BIAS but rounds down to 1 decimal...”

    Only methods like this are more effective.

     

    "however I have no idea how to use this calculated column in the measure for the axis."

    Measure cannot be added to the axis label, you can understand measure as a dynamic value, so you can only rebuild a calculated column.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.