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 had to create a line chart as an user asked in this post: https://community.powerbi.com/t5/Desktop/Line-Chart-With-Values-As-a/td-p/199703 and it worked. Here is my chart:
What I need to do now, is to create a filter for the Category in my chart (Age Range) that doesn't affect the values in the chart, but simply hides the lines (all other filters should work as usual).
For example, when I select Age 18-40, the chart adjusts its values and displays a single line with value 1 (100%),
But I don't want adjusted values, I need the same line of the previuos chart, as if all the other lines have been simply hidden.
Can you help me?
Thank you!
Solved! Go to Solution.
Try this
Production Age =
DIVIDE (
SUM ( 'ANALYSIS AQ_MONITORING_DEEPDIVE'[PRODUCTION] ),
CALCULATE (
SUM ( 'ANALYSIS AQ_MONITORING_DEEPDIVE'[PRODUCTION] ),
ALL ( 'ANALYSIS AQ_MONITORING_DEEPDIVE'[Age Range] )
)
)
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
@corporate - Could you share the pbix file/sample tables and existing measure logic.
Hi @nandukrishnavs , unfortunately with my account I can't share the pbix file, but here is an example of my table:
Month | Target | Region | Age Range | Production |
201912 | Domestico | Lombardia | 18 - 40 | 10 |
201912 | Domestico | Lombardia | 40 - 50 | 15 |
201912 | Micro Business | Lombardia | 18 - 40 | 20 |
202001 | Domestico | Lombardia | 18 - 40 | 5 |
202001 | Domestico | Piemonte | 18 - 40 | 7 |
202001 | Micro Business | Piemonte | 18 - 40 | 15 |
202001 | Micro Business | Piemonte | 40 - 50 | 20 |
202002 | Domestico | Lombardia | 18 - 40 | 15 |
202002 | Domestico | Lombardia | 50 - 60 | 20 |
202002 | Domestico | Piemonte | 40 - 50 | 4 |
202002 | Micro Business | Piemonte | 50 - 60 | 12 |
202002 | Micro Business | Lombardia | 18 - 40 | 16 |
and this is the measure I created and used as Values in line chart:
Production Age =
DIVIDE (
SUM ( 'ANALYSIS AQ_MONITORING_DEEPDIVE'[PRODUCTION] ),
CALCULATE ( SUM ( 'ANALYSIS AQ_MONITORING_DEEPDIVE'[PRODUCTION] ), ALLSELECTED ( 'ANALYSIS AQ_MONITORING_DEEPDIVE'[AGE_RANGE] )))
Thank you!
Try this
Production Age =
DIVIDE (
SUM ( 'ANALYSIS AQ_MONITORING_DEEPDIVE'[PRODUCTION] ),
CALCULATE (
SUM ( 'ANALYSIS AQ_MONITORING_DEEPDIVE'[PRODUCTION] ),
ALL ( 'ANALYSIS AQ_MONITORING_DEEPDIVE'[Age Range] )
)
)
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
It works! Thank you very much!
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |