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

Resolver I

## Percent of Column Total in a Line Chart

Hello Everyone!

My today's issue is this:

I have 2 main tables. One is for the dates and another for the values. So, I was able to make the following matrix.

Where in rows are the types of ships, in columns the years and in values the measure Cant = COUNT('RIESGOS'[ATRAQUE]).

In order to put the porcentage I selected the option "Percent of column total" as you can see in the picture below.

But, this option is not available for the Line Chart. How is the measure that I should do?

I want something like this

Where the individual values for each year add up to 100% (The axis is years, the legend type of ship and the values the percentage)

I tried this formula, but give me the percentage for the grand total:

Pct =
DIVIDE(
COUNT('RIESGOS'[ATRAQUE])
,CALCULATE(
COUNT('RIESGOS'[ATRAQUE])
,ALLSELECTED('RIESGOS')
)
)

And others similiarwith the same result

1 ACCEPTED SOLUTION
Resolver I

@Ramjothi I found the formula in the example 3 of the documents

https://docs.microsoft.com/es-es/dax/all-function-dax

Pct4 = DIVIDE(
COUNTX(
'RIESGOS'
,'RIESGOS'[ATRAQUE])
,CALCULATE(
COUNT('RIESGOS'[ATRAQUE])
,ALL('RIESGOS'[TipoDeBarco]))
)
3 REPLIES 3
Regular Visitor

There is a similar kind of issue discussed in below topic and please try the solution as well.

Solved: Re: Replicate "Percent of column total" in a line ... - Microsoft Power BI Community

Resolver I

Hello @Ramjothi ,

Thanks for participate, I saw that discussion but I didn't know how to adapt it to my case. My values are texts so I can do SUM nor MAX.

And for the other hand, I don't know what to put here "ALLEXCEPT(Sheet1,Sheet1[Date],Sheet1[Question],Sheet1[Country])"

Resolver I

@Ramjothi I found the formula in the example 3 of the documents

https://docs.microsoft.com/es-es/dax/all-function-dax

Pct4 = DIVIDE(
COUNTX(
'RIESGOS'
,'RIESGOS'[ATRAQUE])
,CALCULATE(
COUNT('RIESGOS'[ATRAQUE])
,ALL('RIESGOS'[TipoDeBarco]))
)

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.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors