Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in BI by (2.5k points)

I'm having an issue with a dashboard that I'm creating.

I need to make a Pareto Chart and I found a lot of tutorials on the Internet on how to make it in Power BI, however, I need to use a measure that is a percentage and this is where I'm stuck.

1 Answer

0 votes
by (7.2k points)

First, you need to create a calculated column for the ranking to create a Pareto chart with percentage measure POWER BI:-

Ranking = RANKX(

              SUMMARIZE('Mapa_'; 'Mapa_'[Curso]);

              CALCULATE(

                  DIVIDE(SUM('Mapa_'[Não_]); SUM('Mapa_'[Fat_]));

                  ALL('Mapa_'); 

                  'Mapa_'[Curso] = EARLIER('Mapa_'[Curso])))

After executing the above code then we can create a cumulative measure:

Accum = DIVIDE(

            CALCULATE(

                SUM('Mapa_'[Não_]);

                FILTER(ALLSELECTED('Mapa_');

                    'Mapa_'[Ranking] <= MAX('Mapa_'[Ranking])));

            SUM('Mapa_'[Fat_]))

 

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Browse Categories

...