Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have a report where I have a table for a number of products. The table shows the product ID and then columns for number of sales, profit.
On the report page I have a slicer for year, so that users can select the year they are interested into see the figures for that year.
I have a tooltip that shows the history for sales numbers, so displays year on the x-axis and sales on y-axis. I want this tooltip to show the history for a prodcut when hovering over it BUT at the moment it just displays the figure for that years selected in the slicer. I have turned off 'keep all filters' on the tooltip but then it displays the total sales for all products in those years.
Has anyone successfully managed to achieve something like this before?
Solved! Go to Solution.
@Back2Basics , add what you want to filter in drag parameters
Power BI Tooltip Page: How to pass selective values to the tooltip page: https://www.youtube.com/watch?v=lEq7YtkxeLU
@Back2Basics , add what you want to filter in drag parameters
Power BI Tooltip Page: How to pass selective values to the tooltip page: https://www.youtube.com/watch?v=lEq7YtkxeLU
Many thanks @amitchandak
I realised I had a field from a different table in one of the drill'through field sections. Great video 👍
User | Count |
---|---|
84 | |
80 | |
70 | |
47 | |
43 |
User | Count |
---|---|
108 | |
54 | |
50 | |
40 | |
40 |