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
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.
Mfelix
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
Thank you MFelix. It would be more helpful for me.