Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
@Munawar1881 , I think you need to explore charticulator https://charticulator.com/docs/using-in-power-bi.html
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.
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
User | Count |
---|---|
73 | |
69 | |
36 | |
26 | |
24 |
User | Count |
---|---|
97 | |
92 | |
54 | |
45 | |
41 |