cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Asahara20
Regular Visitor

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

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.

anusha319_0-1639096258349.png

 

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

6 REPLIES 6
apuchakayala
Frequent Visitor

@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
Resolver II
Resolver II

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.comLine 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

@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?

 

apuchakayala_0-1651590002314.png

 

 

Thanks, Anusha

Asahara20
Regular Visitor

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.

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
Super User
Super User

@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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 episode 5 with aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt will talk about the importance of Data Modeling.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!