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.
I have two different visuals on a page, one of them is a progress cloumn graph and other one is a gantt chart. There is also a slicer filtering these visual in terms of dicipline (disiplin). I want to show 'all' in the slicer however when one selects 'all' in the slicer, the progress graph should only show 'genel' in terms of dicipline. (Because 'Genel' means general(all values should be shown for gantt chart) and when you select 'all', graph cumulates all diciplines and 'Genel' is actually not the arithmetic sum of other diciplines.)
Summary: When I select 'all' in the slicer, I would like to show 'all' in gantt chart but only 'Genel' in column graph.
Solved! Go to Solution.
Hi @Anonymous,
First of all don't know if you already have it but you should create a dimension table with the Discipline and relate that table with the data table, then add the following measure:
Total = IF ( DISTINCTCOUNT ( Discipline[Discipline] ) = CALCULATE ( DISTINCTCOUNT ( Discipline[Discipline] ); ALL ( Discipline[Discipline] ) ); CALCULATE ( SUM ( DisciplineValues[Values] ); FILTER ( Discipline; Discipline[Discipline] = "General" ) ); SUM ( DisciplineValues[Values] ) )
The result is below:
Be aware of this things:
Check the PBIX file attach
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português
Hi @Anonymous,
First of all don't know if you already have it but you should create a dimension table with the Discipline and relate that table with the data table, then add the following measure:
Total = IF ( DISTINCTCOUNT ( Discipline[Discipline] ) = CALCULATE ( DISTINCTCOUNT ( Discipline[Discipline] ); ALL ( Discipline[Discipline] ) ); CALCULATE ( SUM ( DisciplineValues[Values] ); FILTER ( Discipline; Discipline[Discipline] = "General" ) ); SUM ( DisciplineValues[Values] ) )
The result is below:
Be aware of this things:
Check the PBIX file attach
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português
Thank you for your help. It worked perfectly as I would.
Now, I need to go one step further and the goal is that when one selects 'General' from the slicer, Gannt chart should show all values instead of nothing. There are even no 'General' in Dicipline column of that table. I could not figure out how to do it.
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 |
---|---|
116 | |
102 | |
78 | |
77 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |