bars in table

Hi powerbiexpert22 ,

I’d like to acknowledge the valuable input provided by MFelix. Their initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue. 

To apply conditional formatting, select a Table or Matrix visualization in Power BI Desktop or the Power BI service. In the Visualizations pane, right-click or select the down-arrow next to the field in the Values well that you want to format. Select Conditional formatting, and then select the type of formatting to apply.

This document provides detailed information about conditional formatting that can help you better understand and use it. I have also added a simple example in the attachment as well, which I hope will help you.

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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