Forum Discussion

alks_skla_f's avatar
alks_skla_f
Icon for Helper II rankHelper II
1 year ago
Solved

Column chart doesn't show information correctly

Hello, I want to show sum of quantity by item category. I have item_cat on x-axis and sum of quantity on y-axis. When I hover bar over, I can see that quantity is correct. Instead of taking sum of qu...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    1 year ago

    Hi,

    Share the download link of the PBI file.

techies's avatar
techies
Icon for Super User rankSuper User
1 year ago

Hi alks_skla_f please check this

 

PercentOfTotal =
DIVIDE(
    SUM('Sheet5'[quantity]),
    CALCULATE(SUM('Sheet5'[quantity]), ALL('Sheet5'))
)
alks_skla_f's avatar
alks_skla_f
Icon for Helper II rankHelper II
1 year ago

please, see my answer above, this solution doesn't work for me