Forum Discussion

Daniel_B's avatar
Daniel_B
Icon for Helper II rankHelper II
6 years ago
Solved

Current vs Previous Month - Best Visualisation to show trend

Hi All   I've created 2 measures which show a count of my positive responses by the current month and previous month (see below) and I wanted to show a simple table which shows the current month po...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Daniel_B ,

    Kindly use your value columns in table instead of measure, use the measure only in conditional formatting.

     


    Best Regards,
    Mail2inba4

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Daniel_B's avatar
Daniel_B
Icon for Helper II rankHelper II
6 years ago

Thanks Anonymous, the visual is starting to look better in terms of data but just one more question.

 

How did you make it so that the value would show next to the arrow as opposed to the 1 or 0?

 

Thanks again

 

Dan_B

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Daniel_B ,

Go to dropdown icon for the particular column, then choose conditional formatting with icons.


Step 1:

Step 2:

Best Regards,
Mail2inba4

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Daniel_B's avatar
    Daniel_B
    Icon for Helper II rankHelper II
    6 years ago

    Thanks Anonymous  - I think I worded my question incorrectly.. Apologies

     

    In your first example, you have the actual values next to the arrows but I have 1 and 0 which are not the values from the calculated month totals

     

    How do I see the actual values for the month instead of 1 or 0 based on the TRUE/FALSE results?

     

    Thanks

     

    Dan_B

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Daniel_B ,

      Kindly use your value columns in table instead of measure, use the measure only in conditional formatting.

       


      Best Regards,
      Mail2inba4

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.