Trying to show chart based on a specific total value as percentage

[rssilvaba]

Hi All,

If you check the sample below, I am trying to have the [# Requests Total] as 100% of the chart axis and the values should be relative to that. But if I move it to the values and change them to grand total % the values are all down to the chart.

I was able to get the relative total but that is not what I am trying to do. In the sample as it is the total 100% should be 68, the line should go exatcly to 5% mark in the graph and the value from [# Requests Urgent] should be relative to [# Requests Total].

Any ideas? Here is the sample
sample 

Thank you very much.

[Greg_Deckler]

@rssilvaba - I downloaded the PBIX but I can't understand what you are trying to achieve. Can you point to the visual you want modified and maybe mock up what you are trying to achieve in Paint or something?

[rssilvaba · Accepted solution]

@Greg_Deckler Sorry, I might have not been clear but just by posting the question I can see that I was trying the wrong approach.

So I resolved it with the measure:

# Requests Urgent % = [# Requests Urgent]/[# Requests Total]

 And then setting the format to Percentage.
After, juut needed to change the Values to the new measyre [# Requests Urgent %] and to have the line in the right place we also need to use a constant line instead of a percentage line. Unless you do the same for the KPI measure.

[Greg_Deckler]

@rssilvaba - I often find that when I sit down and write out a problem the answer becomes obvious! 🙂