Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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.

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
Anonymous
Not applicable

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.

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.

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.