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 positive count and some kind of visualisation which shows whether it is higher or lower than the previous month (a plus/minus or up/down arrow) 

 

Current Month

MTD Postive = CALCULATE((Sheet1[PositiveCount]),DATESMTD('Calendar'[Date]))

 

Last month measure

LM Positive = CALCULATE((Sheet1[PositiveCount]), DATESMTD(ENDOFMONTH(DATEADD('Calendar'[Date],-1,MONTH))))
 
The measures work in terms of showing the right data comparison but I'm struggling to make it into a visualisation that is useful/simple in showing the month on month trends
 
Any ideas of what to do and even if my measures are the right type for this would be great

Thanks

Dan_B
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.

6 Replies

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    6 years ago

    Hi Daniel_B ,

     

    You can create one measure like below:

    Measure =
IF ( MTD Postive> LM Postive, UNICHAR ( 9650 ), UNICHAR ( 128315 ) )

    Then use this measure in your table.

     

    Please give KUDOS to this effort and also accept this as a solution if it helps!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Daniel_B ,

    Please create your measure to find the Last Month comparison like below.

    Met/Not_Met = IF([Last_Month]>[Current_Month]],1,0)

    Based on this measure create a conditional formating with Icons to acheive your request.



    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.