Forum Discussion
Tooltip in Visuals
Hi Prakash1050 ,
My approach would be to create a disconnected table with one column containing all the labels for your current and previous bar segments, create a measure based on SWITCH DAX function to choose the measure based on the bar segment, and replace the two measures in the bars with the one column. This way, the context of the bar segment, current or previous, is also transferred to the tooltip page. There you can do the same, create a disconnected table with a row for each potential pie segment that should occur in the tooltip anywhere, use this as categories for the pie cahrt, and create another measure that reacts on the current or previous context from the bar chart and the segments of the pie chart and returns each value as needed in each context. E.g. if SELECTEDVALUE of your disconnected table for the bar chart is "current", the measure for the pie chart returns values for some segments and blank for others while if SELECTEDVALUE of your disconnected table for the bar chart is "previous" then the measure for the pie chart returns values for some other segments as with "current" and blank for others. So it's basically the same pie chart in the tooltip for both bar segments, but showing different measures or categories depending on the current or previous context from the bar chart. You can even apply same or different colors for the pie segments shown in current or previous context in the formatting pane of the pie chart.
BR
Martin
- Prakash10503 years agoHelper III
Hi Martin_D ,
Thanks for reply. But the current month and previous month values comes only when the date is filtered. So, The disconnected table we can't create and the value also coming not correctly. any other logic to done this scenario please share it.
Thank You