Forum Discussion

sharong's avatar
sharong
Icon for Helper I rankHelper I
3 years ago

Text measure as legend in scatter plot

I am creating a scatter plot with X axis and Y axis are direct columns from the table. In “Values”, I have customer name and customer number. For the legend, I have a calculated measure “persistence”...
visheshjain's avatar
visheshjain
Icon for Impactful Individual rankImpactful Individual
3 years ago

Hi sharong,

 

I took a quick look at it and wasn't able to get the exact solution to your problem.

 

However, conditional formatting kinda worked, but still won't show text.

Here is a version of your measure that I used for the conditional formatting of the data points.

Persistence Color =
SWITCH (
    TRUE (),
    [long term (only)] < [short term (only)], "Red",
    [long term (only)] > [short term (only)], "Green",
    "Yellow"
)

 

Since your upper and lower thresholds are dynamic, we can't even create a calculated column.

I haven't tried the dis-jointed table method yet but will try it tomorrow probably.

 

Thank you,

Vishesh Jain

  • sharong's avatar
    sharong
    Icon for Helper I rankHelper I
    3 years ago

    Thanks for the update visheshjain please do try dis-jointed table method and let me know if it works better than this conditional formatting method. This conditional formatting of data points satisfies the requirement. I have included 

    "Payment delay persistence only short" into the tooltips of scatter plot and now text shows up in tooltip. But I also want to bring it as a slicer. Is there any way to bring this as a slicer also.
    Thanks in advance for your kind help. Grateful!
    • visheshjain's avatar
      visheshjain
      Icon for Impactful Individual rankImpactful Individual
      3 years ago

      Hi sharong,

      *****EDIT****

      Just thought of something, that we can use Query parameters and probably create a calculated column based on that.

      This way you lose a little bit of flexibility of the slicer and the report will need to be refreshed, but it just might work the way you want it to. So there is a trade-off.

      I need the source excel file aka Sheet1 of your data to make changes to the query, so please share that or a sample file if possible.

       

      *****Edit Over****

       

      I gave it a shot but couldn't get anything to work exactly the way you would have wanted.

       

      Since it is a scatter plot and it accepts only columns, nothing worked.

      I also tried to go the Calculation Group route, but didn't work.

       

      Sorry couldn't be of much help here and you are more than welcome to accept one of your own responses as the solution to this post.

       

      Thank you,

      Vishesh Jain