cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## Percent of grand total, by X Axis

Hi all,

I know this question has been asked in a number of ways but i can't get the other answers to work for me.

I have this graph -

Using these fields -

For Values, I am using percent count of grand total, but i need this to calculate percent count per Quarter/Year, so 2020 Q1 has these percentage values -

I understand from pervious responses that I need to create a Measure, potentially using the following formula -

Measure =

DIVIDE (

CALCULATE (

SUM ( Table[Amount] ),

ALLSELECTED ( Table ),

VALUES ( Table[Role] ),

VALUES ( Table[Date] )

),

CALCULATE ( SUM ( Table[Amount] ), ALLSELECTED ( Table ) )

)

I have tried putting my field names into this formula but unfortunately I cannot get this to work. Could someone please help a relative novice?

Thanks!

1 ACCEPTED SOLUTION
Super User

@lewisgrantevans

Try this measure:

``````Measure =
DIVIDE (
SUM ( Table[Amount] ),
CALCULATE (
SUM ( Table[Amount] ),
ALLSELECTED(Table[Turnaroundtime])
)
)``````
Did I answer your question? Mark my post as a solution! and hit thumbs up
3 REPLIES 3
Super User

@lewisgrantevans

You use a 100% stacked column chart instead of a line chart. The chart will do the calculation  for you.

Did I answer your question? Mark my post as a solution! and hit thumbs up
Regular Visitor

The 100% stacked column chart certainly gives me the correct percentages but i need to visualise it with a line chart, like this -

This is one of the most basic excel charts and it's a shame there is no Power Bi equivalent. Do you think I can achieve this with a Measure?

Super User

@lewisgrantevans

Try this measure:

``````Measure =
DIVIDE (
SUM ( Table[Amount] ),
CALCULATE (
SUM ( Table[Amount] ),
ALLSELECTED(Table[Turnaroundtime])
)
)``````
Did I answer your question? Mark my post as a solution! and hit thumbs up

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.