Forum Discussion
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...
Hi,
Share the download link of the PBI file.
Hi,
Try these measures
Total = sum(Data[Qty])
Measure = divide([Total],calculate([Total],all(Data[Item_cat])))
Format Measure as %,
Hope this helps.
Hello, still doesn't work:
Total_num_qty = SUM('pizzeria orders'[quantity])test = divide([Total_num_qty],calculate([Total_num_qty],all('pizzeria item'[item_cat])))Is there any other solutrion, please?
Hi,
Share the download link of the PBI file.
