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.
Hello,
I have a cluster bar chart with a line. Because of the values of the line chart I would like the line to only when someone drills into a specific part of the report. Is this possible?
E.g. I have the bar chart with domains then the line going across but when they drill into a specific domain the line changes based on what is showing. On the top part of the chart I would like to hide or not show the line but when they drill into the specific domain the line shows up.
Thanks
Jes
Solved! Go to Solution.
Hi @jesscajasper,
You need to add a measure to be part of your line, for example if you have a date field and you add this measure:
Only Months = IF(DISTINCTCOUNT(Table1[Date].[Month]) > 1 ; BLANK(); SUM(Table1[Value])
The line will only appear when you drill down to the month level and not on any other.
You need to adapt the measure to your needs.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @jesscajasper,
You need to add a measure to be part of your line, for example if you have a date field and you add this measure:
Only Months = IF(DISTINCTCOUNT(Table1[Date].[Month]) > 1 ; BLANK(); SUM(Table1[Value])
The line will only appear when you drill down to the month level and not on any other.
You need to adapt the measure to your needs.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
113 | |
103 | |
76 | |
66 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
81 | |
68 |