Comparing Current Period to Previous Period

[Anonymous]

Hi Everyone,

I am working on a dashboard. In the upper left-hand corner of the image below, there are four benchmarks. Grouped verticle from left to right we are comparing total visitors this year to total visitors last year, new visitors this year to new visitors last year, returning visitors this year to returning visitors last year, and total page views this year to total page views last year. Is there a more visually appealing way of doing this? What we would like to do is compare the current period and the previous period by showing the increase or decrease from the previous period based on the total number and based on % change. We would potentially like to add an arrow that points up or down depending on how the traffic has changed.

Thank you for any suggestions.

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

You can add a dynamic arrow in it. The icon with conditional format can achieve what you want.

All icon names are here.

This is a simple sample you can refer to.

You can check more details from the attachment.

About conditional formatting, you can refer to Use conditional formatting in tablesables.

Best Regards,

Stephen Tao

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