Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have a bar chart of current and previous month measures.
And I need to show two different types of tooltip (Two different Pie Chart Visuals for current and previous month) from hover the bar chart visual.
Please help me to done this scenario.
Thanks in Advance.
Like Above Images. It shows only one piechart in tooltips. But I Need Different type of piechart for current and previous month.
I think this problem can be solved in the measures. Would you like to share your file to show how it works with the constraints of your file, and provide additional images of what the other pie chart quickinfo should look like?
Sure,
This Image For Current Month.
This Image for Previous Month.
The visual is Bar Chart and have two measure 1.Current Month 2. Previous Month.
If i hover the current month bar it shows 1st image and hover previous bar it shows second image.
These image done by two card visual before the bar chart visual and the card visual have these tooltips. But i don't want these card visual tooltip. I want bar chart visual tooltips.
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
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
User | Count |
---|---|
13 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
24 | |
3 | |
3 | |
2 | |
2 |