Trying to create donut chart with percentage

[Anonymous]

Hello,

I am trying to create donut chart with percentage view but its not working for me.

 The total receipt is 4, measure I am using -> total receipt = Sheet1[Receipt Initiated After Effective Date]+Sheet1[Receipt_rest]

where 1 is receipt initiated after effective date, measure I am using-> 

Receipt Initiated After Effective Date = COUNTROWS(FILTER(Sheet1,Sheet1[Business_Process_Type] = "Receipt" && Sheet1[Date_and_Time_Initiated]>Sheet1[Effective_Date]))

and 3 is Receipyt rest, measure I am using -> 

Receipt_rest = COUNTROWS(FILTER(Sheet1,Sheet1[Business_Process_Type] = "Receipt" && Sheet1[Date_and_Time_Initiated]<=Sheet1[Effective_Date]))

I need to show in the donut chart as percentage -

1/4 & 3/4

But in the donut, something diff coming!

kindly help!

[v-kelly-msft · Accepted solution]

Hi  @Anonymous ,

Do you wanna show as below:

If so,remove the total measure from the donut field:

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

Hi @sayaliredij,

 Still not clear.

Actually I am fairely new to powerBi

Is there any option here to attach my dashboard?

[sayaliredij]

Can you add pbix file (after removing sensitive data) at some dropbox location?

[Anonymous]

Hello @sayaliredij ,

I tried to add the pbix but below error is showing-

[sayaliredij]

You can not add in Forum but you have to add using drop box or one drive. 

[sayaliredij]

As these 3 attributes are separate measures. It is not possible to fit them in a single donut. But you can do the following

1. In your main table, add column "category" and you can categorize each receipt using this calculated column

2. Then you just need to create one measure eg. COUNTROWS(Tab) 

3. use this measure for donut chart and in the legend - specify category

Thanks,

Sayali 

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

[amitchandak]

@Anonymous , Donut chart showing % , is that calculation not correct. I doubt you can display 1/4, 3/4 etc

[Anonymous]

Hi @sayaliredij ,

Can you help me with the below -

1. In your main table, add column "category" and you can categorize each receipt using this calculated column - What would be the dax formula?

2. Then you just need to create one measure eg. COUNTROWS(Tab) - Measure as in?

[sayaliredij]

I dont know how exactly the data look like

But I could imagine something like this

Category = IF('Table'[Effective Date] < 'Table'[Date Time Initiated],"Receipt Initiated After Effective Date","Receipt Rest")

Once this column is created 

You can create measure as follows

Receipt Count = COUNTROWS(table)

Regards,

Sayali

[Anonymous]

Hi @sayaliredij ,

Not working.

here is the data -

[sayaliredij]

I used the following data

Category has formula as below

Category = IF('Table'[Effective Date] < 'Table'[Date Time Initiated],"Initiated After Effective Date","Rest")

Measure Formule is 

Receipt Count = COUNTROWS('Table')

and Put a filter/slicer with Receipts - as you are only interested in receipts

Please check if this works. Make sure you have else condition in the formula 

Regards,

Sayali

[Anonymous]

Hello @amitchandak ,

Can you guide me with the right approach?

I think formulas are not correct?