Display custom text tooltip on different Bars in Clustered and bar Chart

[Asahara20]

Hi Team,

I hope someone will be able to help me find a solution for the below scenario:

1) I have line and clustered Bar chart created using 4 different measures.

2) I have new page with table visual having 2 different columns all of text values which I will be using as a custom tooltip on line and clustered chart.

Question: When I am trying to displaying the tooltip it is showing the tooltip on all 3 bars and line chart data point for that FY and month. Since the bar chart is based on the measure values. How can I display tooltip related to that measure? 

Thanks,

A

[apuchakayala]

@amitchandak :   Can you please let me know if the feature to display different annotations on different bars in a clustered chart a proposed idea? or we need to raise the idea?

[Mayank_Yavda]

Hi @Asahara20,

Here is Line and clustered column chart With Custom Tooltip which will help you to get different tooltip for each chart.

Line and clustered Column Chart with custom tooltip PBIVizEdit.comLine and clustered Column Chart with custom tooltip PBIVizEdit.com

Download link for the custom visual file in this page

https://pbivizedit.com/gallery/line-and-clustered-column-with-custom-tooltip 

This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,

• anyone, irrespective of technical skills, can create their own visuals
• 15 minutes to create a visual from scratch
• opens up many additional attributes to edit (for e.g. labels, tooltips, legends position, etc)

Give this a shot and let us know if you face any problem/errors.
You can use the editor to modify your visual further (some modifications cannot be done in Power BI window and have to be in editor).

Thanks,
Team PBIVizEdit

[apuchakayala]

@Mayank_Yavda @amitchandak 

Thankyou all for your time in replying back to my question.

Below is how my report page should look like:

here is the scenario: There are 4 different items that have to be displayed in the clustered bar and line chart.

Bar chat has scanned items, flagged items, reviewed items and these are called as metric names: 3 different measures are created to display these metric values.

Now, I have created an additonal page in the same report to display that page as tooltip.That can be seen in below image.

So my requirement is if the metric name in the tooltip page = scanned content items then the tooltip has to display only on that bar for that month and year. But instead currently even the metric name = scanned content items the tooltip is displayed on all 3 metric bars.

so now I have 2 different tables

1) Table 1 has all data related to the 3 metric names along with other data.

2) Table 2 has all data related to tooltip

I have created new common column in both the tables with date&itemid&metric name in both the tables to make each row unique and joined the tables.

So, can someone please suggest as what can be done to meet my requirement, if the feature does not exist can we raise a feature request?

Thanks, Anusha

[Asahara20]

The tooltip is needed to show the data anamolies. This is all manually entered text data which is coming from excel file.

Example: in the bar visual we have 3 cluster bars ( lets call them A,B,C ) and one Line chart (D)

So, for A we have one data anomaly which we want to show when the user hovers on bar A.

So, for B there are no data anomalies so when user hovers mouse on Bar B the tooltip should not display any text.

Now for C there are 2 data anomalies so when user hovers mouse on Bar C the tooltip should display those 2 text items..

As I mentioned all A,B,C and D are measures. So with the current tooltip it is displaying all three 3 text items( 1 of A and 2 of B) on Bar A, B,C and Line chart D.

[v-janeyg-msft]

Hi, @Asahara20 

What does data abnormality mean? I don’t understand your needs very well, So I’m not sure if it can be realized.

Can you share some sample data and your desired result(If you can’t use visual to display, pictures are also okay)? So we can help you soon.

Best Regards,
Community Support Team _ Janey

[amitchandak]

@Asahara20 , Is there a filter in the measure which you need to pass, that is not possible as of now.

If you want to change tooltip based on the measure, that is also not possible

What is the exact need