Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Everyone,
I'm trying to make a histogram with a year-by-year comparison of answers 1 to 5.
it gives me this :
My question is about the total : I don't kown how to have 100% by year (legend).
My problem is that the total per year is not 100%. It's the sum of all my bars that is 100%.
May you help me ?
Thanks a lot !
Solved! Go to Solution.
I don;t think it;s possible with just UI, you will need to:
1) create a new measure (press 'New Measure' in Modelling in the ribbon)
2) syntax should be something like this - you will need to adjust the blue parts
this code assumes that Annee is a numeric field, not text
% of total = VAR varYear = MAX ( Table[Annee] ) RETURN DIVIDE ( SUM ( Table[Nombre de Quel...] ), CALCULATE ( SUM ( Table[Nombre de Quel...] ), Table[Annee] = varYear ) )
You may use measure below.
Measure = DIVIDE ( SUM ( Table1[value] ), CALCULATE ( SUM ( Table1[value] ), ALLSELECTED ( Table1[answer] ) ) )
You may use measure below.
Measure = DIVIDE ( SUM ( Table1[value] ), CALCULATE ( SUM ( Table1[value] ), ALLSELECTED ( Table1[answer] ) ) )
Thank you ! Sorry, I did'nt saw your answer before !
I don;t think it;s possible with just UI, you will need to:
1) create a new measure (press 'New Measure' in Modelling in the ribbon)
2) syntax should be something like this - you will need to adjust the blue parts
this code assumes that Annee is a numeric field, not text
% of total = VAR varYear = MAX ( Table[Annee] ) RETURN DIVIDE ( SUM ( Table[Nombre de Quel...] ), CALCULATE ( SUM ( Table[Nombre de Quel...] ), Table[Annee] = varYear ) )
what's the syntax for the [%TG...] measure?
I only put this params :
Do you have an idea ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |