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 alks_skla_f ,
There are two approaches are we can do,
1) using dax -->test=divide(sum(test_table[quanity]),(calculate (sum(test_table[quanity]),All(test_table[item_cate))
2)Go to Y-axis in visual and right click on y-axis the and select show as value option and from there you can select Percentage of grand total.
Regards,
Surya.
please, see my answer above, this solution doesn't work for me
