Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
So I have a stacked column chart that has values color coded by groupings. So when I mouse over the chart, the tooltip only shows the value for the group I am currently mousing over. Is there a way to make the tooltip show the value for all the groups when I mouse over any portion of the chart? I have attached a highely redacted screenshot to illustrate 🙂
So for the fiscal period I've selected it only shows my the value of 10 which is the value for group 1, is there a way so that if I mouse over any portion of that column it will show me all values for all groups?
Thanks
Solved! Go to Solution.
Hi there,
It looks like you can do this if you use a Report Page Tooltip but not a regular tooltip.
I have shared a PBIX here with a very simple example.
The key thing is to set up the Tooltip Report Page so that the Keep all filters = Off and the filter you want to be passed (e.g. Fiscal Period) dragged to the Tooltip fields well.
Then only the Fiscal Period will be passed through as a filter to the tooltip.
Are you able to get that working in your case?
Regards,
Owen
Hi @id013 ,
We can create a measure and use it in tooltips field to meet your requirement:
Tooltips Measure =
CONCATENATEX (
SUMMARIZE (
CALCULATETABLE (
DISTINCT ( 'Table'[Legand] ),
FILTER (
ALLSELECTED ( 'Table' ),
'Table'[X-axis]
IN FILTERS ( 'Table'[X-axis] )
)
),
'Table'[Legand],
"TotalValue", CALCULATE (
SUM ( 'Table'[Value] )
)
),
[Legand] & ": " & [TotalValue]
& UNICHAR ( 10 )
)
Best regards,
Hi @Shruthi96 , were you ever still able to get the percentage beside the total value? I am struggling with the same issue and would like to know if (and how) you solved it. Many thanks.
Thank you very much for your suggestion. I will keep that in mind for other situations but in this case I felt the other suggestion would be easier to implement as I don't want to be creating too many measures in this case.
Hi there,
It looks like you can do this if you use a Report Page Tooltip but not a regular tooltip.
I have shared a PBIX here with a very simple example.
The key thing is to set up the Tooltip Report Page so that the Keep all filters = Off and the filter you want to be passed (e.g. Fiscal Period) dragged to the Tooltip fields well.
Then only the Fiscal Period will be passed through as a filter to the tooltip.
Are you able to get that working in your case?
Regards,
Owen
Thank You !!!! This solution worked magnificently. Thanks. One thing I did notice though that when I drag the fiscal period fields into the tooltip fields, all the visuals that have tooltip set to report page -> auto now display the new tooltip instead of the default. Is that normal? Either way I can get around it by setting those to default instead but I was just curious if that's a bug or on purpose.
@id013 Glad that worked for you 🙂
I expect that's meant to be a "helpful" behaviour, but I can see that it might not be desirable.
It may depend on which fields are present in the visual(?)
Yes I expect you are stuck having to change to default manually.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
105 | |
98 | |
39 | |
30 |