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 UserDon't forget to turn auto-size of columns to off in the table options.
Mfelix
Mfelix
PitchaimuthuHelper II
Helper IIThank you MFelix. I have one more doubt, My dashboard data wants to show the current quater and previous quater values. Can you provide me?
- MFelixHow 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.
- 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