Forum Discussion

LABORSAL's avatar
LABORSAL
Icon for Advocate II rankAdvocate 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
LABORSAL's avatar
LABORSAL
Icon for Advocate II rankAdvocate 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
Icon for Community Support rankCommunity 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.