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.
How can you pick and choose which filters a tool tip uses please?
Here is how to create the problem …
Firstly create a tool tip
Create a Tool Tip page with Stacked Column Chart
with Axis = Month Year
and Value = Sales Quantity
Filter = date range must be in last 12 months
Set keep All Filters = On
Then create a main report using the tool top
Create a report page with a Stacked Bar Chart
with Axis = Product type
Value = Sales Quantity
Filter = date range must be in last 1 month
set the tool tip = the above tool tip page
Now test the reports with Keep All Filters on
Now when you hover the mouse over a product then the tool tip will only show 1 month for the 1 product because it has Keep All Filters On.
See top screen print.
Test the main reports with Keep All Filters off
Change the tool tip report to Keep All Filters = Off
Now when you hover the mouse over a product then the tool tip will only show 12 months for all products because it has Keep All Filters Off.
See bottom screen print.
Question
How can I make the tool tip show all the months for just the product being hovered on please?
Solved! Go to Solution.
Hi @speedramps ,
I couldn't find any official documents. You could send feedback about "Drag tooltip fields here" here to let author add some descriptions.
Hi @speedramps ,
You could add the Product Type column in the "Drag tooltip fields here" (tooltip page) and check all the type with Ctrl+Left Click.
Don't forget to turn off "Keep all filters". Here is the result.
Many thanks to Community Support Team _ Eads for the quick reply.
That was really helpful.
I have used a slightly different solution.
On the tooltip page I set Keep All Filters = off
and dragged Product Type to "Drag tooltip fields here".
It defaulted to “Product Type is (All)” and I didn’t think it wise to use Ctrl+Left click, because if more product types are added later then they would not be selected. Much better to leave it with “Product Type is (All)” I think.
It seems to work ok but I don’t understand how it works and I can’t find any documentation about to "Drag tooltip fields here" and the “Summarized” or “Use as category” options. Please cam you provide a link to any documentation on these?
See screen print.
Hi @speedramps ,
I couldn't find any official documents. You could send feedback about "Drag tooltip fields here" here to let author add some descriptions.
Many thanks to Community Support Team _ Eads for the quick reply.
That was really helpful.
I have used a slightly different solution.
On the tooltip page I set Keep All Filters = off
and dragged Product Type to "Drag tooltip fields here".
It defaulted to “Product Type is (All)” so I didn’t think it wise to use Ctrl+Left click, because if more product types are added later then they would not be selected. Much better to leave it with “Product Type is (All)” I think.
It seems to works OK but I don't understand how it works and I cant find any documentation about to "Drag tooltip fields here" and the “Summarized” or “Use as category” options. Please can you provide a link to any documentation on these?
I have attached a screen prints.
Thank you
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |