## Desktop

Highlighted
Regular Visitor
Posts: 23
Registered: ‎07-13-2018

# Display data as sum of percentage in different catagory

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

Moderator
Posts: 9,151
Registered: ‎03-06-2016

## Re: Display data as sum of percentage in different catagory

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Posts: 9
Registered: ‎10-06-2018

## Re: Display data as sum of percentage in different catagory

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: