Visual Guide

[Munawar1881]

I have a column name buying department and its value is Infant, Boy, Girl, Man, Women and Others I need it to display them horizontally with their total value as shown in first image. please help me to find the way. how can I solve it, and also how can I get the value of each cetagory (infant total value, or boy total value) etc 

[amitchandak]

@Munawar1881 , I think you need to explore charticulator https://charticulator.com/docs/using-in-power-bi.html

[Munawar1881]

I have a table with these categories and want their total values like below

how can I do that you can do it in may practice sheet. 

I need the total value of categories which are in column. 

[Anonymous]

Hi @Munawar1881 ,

It looks like the images above your values are inserted.

And about wanting their totals, you could count them. Try to use the COUNT() function or COUNTROWS() function.

For example,

Measure= COUNTROWS(FILTER(ALLEXCEPT('TableName', [Buying Dep]=MAX('TableName'[Buying Dep])))

Best Regards,

ShundaSteph