cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joshcorti11
Helper III
Helper III

Comparing Current Period to Previous Period

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.

 

example.PNG

 

Thank you for any suggestions.

1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

Hi @joshcorti11 ,

 

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

All icon names are here.

Screenshot 2021-07-12 174025.png

 

This is a simple sample you can refer to.

8.pngScreenshot 2021-07-12 174302.png

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.

 

View solution in original post

1 REPLY 1
v-stephen-msft
Community Support
Community Support

Hi @joshcorti11 ,

 

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

All icon names are here.

Screenshot 2021-07-12 174025.png

 

This is a simple sample you can refer to.

8.pngScreenshot 2021-07-12 174302.png

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.

 

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!