Forum Discussion
Pitchaimuthu
Helper II
Helper IIHow 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
MFelix
Super User
Super UserHow 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
PitchaimuthuHelper II
Helper IIHi 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.
- MFelixPitchaimuthu,
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.