Hi,
I have a line chart with one measure. I have a dimension(which has 4 values) on color.So I have four different lines on my line chart . Is it possible to customize the tooltip for each line(each value of the dimension)?
Thankyou in advance.
Hi @Neema Sujatha
I would need to know a little more about how you want to be formatting the tooltip.
If you want to dynamically change the color of the title, for example, that can be achieved by creating four boolean expressions:
A Title
IF [Bucket] = "A" THEN [Bucket] ELSE "" END
B Title
IF [Bucket] = "B" THEN [Bucket] ELSE "" END
...and so on.
Add all 4 to tooltip and list them together, editing their color:
<A Title><B Title><C Title><D Title>
(each of these fields will be in a different color)
Only the highlighted point will trigger the colored title to appear-- the others will not be visible.
If you want more complex formatting, you may be able to trick it using Viz in Tooltips:
- Create a worksheet for each of your color dimensions {A, B, C, D}
- Format each worksheet area so they give the appearance of the tooltip you wish to see.
- Create four boolean calculations: IIF([Bucket]="A",[Bucket],null) for A-D
- Drop these checks on the appropriate worksheet, making sure they are marked only for TRUE; I also moved mine to context
- Add all 4 worksheets into your tooltip using Tooltip--> Insert --> Sheet
- When selecting a point, the worksheet will appear as a tooltip, limited to the scope of the selected color bucket.
- Note: you may need to change your viz-in-tooltip filter from "<All Fields>" to just "<Bucket>"
Hope this helps!
