Day Wise percentage calualtion using text feild

[Anonymous]

Hi, I am trying to find a way to calculate the day-wise percentage using the text field. My data looks like this, 

Date	Category
1-11-2020	A
1-11-2020	B
2-11-2020	A
2-11-2020	B
2-11-2020	C
3-11-2020	A

I have used "show value as - percentage of grand total".

it shows me a result something like this 

the result i am getting now

But i need date wise percentage bifurcation like below, where day total percentage should be 100%

1-11-2020	A	34%
1-11-2020	B	76%

Can some one help me in getting the result i need. 

Regards

Ela

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

According to your description, I think that you can use Matrix chart in Power BI to achieve this, you can try my method:

Create a Matrix chart, and place columns like this:

And you can get what you want.

You can download my test pbix file here

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-robertq-msft  Thank you, it does serve the purpose.

[amitchandak]

@Anonymous ,

You an GT with Measure like

divide([measure], calculate([measure],all(Table))

or
divide([measure], calculate([measure],allselected(Table))

Or you can use percent of the total in the values field

[Anonymous]

@amitchandak , thanks for the reply. I am now your youtube follower. great videos and Kudos on SQL Vs DAX topic. Keep going.