Forum Discussion
Solved
How to create comment Icon in table?
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...
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
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?
How is your data setup?
Do you have a date column? What do you.want to summarize by quarter sum, count?
Mfelix
Do you have a date column? What do you.want to summarize by quarter sum, count?
Mfelix
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.
- 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.
MfelixThank you MFelix. It would be more helpful for me.