Displaying Value as Percent of Month rather than Grand Total

[SamTrott]

This is a issue which creates a lot of topics but since every is using very different data sources the answer is always different, its something Excel does with ease so its frustrating that its simply not present in BI.

So I have a Graph that looks like so, what I want is instead of displaying the actual value I'd like it as a percentage for that month. Currently the only option is to show the values as percentage of grand total.

The value in this case is a measure which counts all the rows in a table. Each record has a date entry and a case type entry (among others). 

Please let me know if you need anymore information to help me overcome this hurdle. My knowledge of how to create measures is very limited 😞 so any documentation that may help me get a better grasp of how to write them would be helpful too.

Thanks,

Sam

[v-joesh-msft · Accepted solution]

Hi @SamTrott ,

You can create the following measure:

Volume percentang = 
DIVIDE (
    [Volume],
    CALCULATE ( [Volume], ALLSELECTED ( 'Table'[case type] ) )
)

Results are as follows:

Here is a demo, please try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EWM9SaCYHQZGpzyEN7...

Best Regards,

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

[SamTrott]

Hi @v-joesh-msft ,

Thank you for your rseponse, unfortunately this does not seem to have worked. Using the fields and tables names for my data source I tried both 

Volume percentage = 
DIVIDE (
    'dAccount'[Count of Cases Created],
    CALCULATE ( 'dAccount'[Count of Cases Created], ALLSELECTED ( 'fIncident'[Case Type] ) )
)

and

Volume percentage = 
DIVIDE (
    [Count of Cases Created],
    CALCULATE ( [Count of Cases Created], ALLSELECTED ( 'fIncident'[Case Type] ) )
)

but both display the graph like so

The proportions of the bars seems to be correct but the Data labels are obviously not. 

Thanks in advance!

Sam

[v-joesh-msft]

Hi @SamTrott ,

You can check if the measure format is set correctly, as shown in the figure below, select the measure “Volume percentage”—Formatting, and then you can adjust the format accordingly.

Best Regards,

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

[SamTrott]

Hi @v-joesh-msft ,

Thanks that has indeed fixed labels. I've marked your first response as the solution since it contained the relevant measure I was missing.

Thank you for your help.

Regard,

Sam