Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Everyone
I am new to power BI, i am facing a problem with my data i have to 2 columns one column contains value of different catogories like(LO,CD,DI(a,b,c,d,e)) I need to display that colmn as perentage in three catagories as LO,CD and remaining as DI in table and pie chart
in table wise it shpuld show out of 100% how much is LO,CD and DI same i ahve to show in pie chart also and percentage on the visuals
Can u plz help me
Example of my data and visuals
Hello Aryan,
So to display these informations you can simple create another column classifying the information on each line for example:
Add another column called = Class as showed below:
After creating this column you have just to do a measure DAX formula for example:
Total Value = SUM('Data Tale'[Value])
After creating the Measure Total Value create another to lock the total value
Total Value Blocked = CALCULATE([Total Value];ALL('Data Table'))
and now one more Measure responsable for % porcentage
% Value por Class = DIVIDE([Total Value];[Total Value Blocked];BLANK())
Click on this last measure on created and format his time to %
And now if measures ready you can create the Graphics: selecting the View and the fiels as showed below:
Please if you have any doubt please type here
I hope i've helped
Hi @aryan,
>> i am facing a problem with my data i have to 2 columns one column contains value of different catogories like(LO,CD,DI(a,b,c,d,e)) I need to display that colmn as perentage in three catagories as LO,CD and remaining as DI in table and pie chart
in table wise it shpuld show out of 100% how much is LO,CD and DI same i ahve to show in pie chart also and percentage on the visuals
Please share some dummy data for us and clarify your desired results based on these sample data.
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |