Current vs Previous Month - Best Visualisation to show trend

[Daniel_B]

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

[Anonymous]

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]

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]

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]

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 · Accepted solution]

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.

[Tahreem24]

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!!