How to create comment Icon in table?

[Pitchaimuthu]

I have table billing information. In this table having the comment column, it is showing the length of text line. So I need to create comment icon for that fields intead of showing the length of text line. whenever the user click on the icons it needs to show the text information. below my sample screens, like this I need to to in Power BI table. Please give how to do this?

[MFelix · Accepted solution]

Hi @Pitchaimuthu,

Curently in Power BI you can't add a tooltip to the table view but you can add the comment in your table and adjust the size of the column until you see the "..." that way if the user overs the mouse on that spot it will see the comment.

Regards,

MFelix

[Pitchaimuthu]

Thank you @MFelix for your response. 

[MFelix]

Don't forget to turn auto-size of columns to off in the table options.

Mfelix

[Pitchaimuthu]

Thank you @MFelix. I have one more doubt, My dashboard data wants to show the current quater and previous quater values.  Can you provide me?

[MFelix]

How is your data setup?

Do you have a date column? What do you.want to summarize by quarter sum, count?

Mfelix

[Pitchaimuthu]

Hi @MFelix

Yes I have date fields. My sales report wants to show the current quater and previous quater sales data. When the user open the dashboard it needs to show by default with Current quater and previous quater sales data. 

[MFelix]

@Pitchaimuthu,

Use the measures below:
Sales Current Quarter = TOTALQTD(SUM(SALES TABLE[Sales]), Dates table[Date])
Sales Previous Quarter = TOTALQTD(SUM(SALES TABLE[Sales]), DATEADD(Dates table[Date],QTD,-1))

This should work.

Mfelix

[Pitchaimuthu]

Thank you @MFelix. It would be more helpful for me.