Forum Discussion

ArslanManzoor's avatar
ArslanManzoor
Frequent Visitor
5 years ago
Solved

3 month rolling data visual

Hello!   Please can someone help with a problem I am having with Power BI. I have 2 tables below (data sources), the first table is showing the time taken to do tasks A and B over a few months, thi...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, ArslanManzoor 

    Please check the below steps.

     

    Write a measure something like below.

     

    Conditional Format measure =
    SWITCH (
    TRUE (),
    [Time Taken Avg for Visualization]
    > 1.05 * SELECTEDVALUE ( Target[Target] ), 1,
    [Time Taken Avg for Visualization]
    <= 1.05 * SELECTEDVALUE ( Target[Target] )
    && [Time Taken Avg for Visualization]
    >= 0.95 * SELECTEDVALUE ( Target[Target] ), 2,
    [Time Taken Avg for Visualization]
    < 0.95 * SELECTEDVALUE ( Target[Target] ), 3
    )
     
    Setup like below.
     
     
     
     

    Hi, My name is Jihwan Kim.


    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

Pricey79's avatar
Pricey79
Helper V
5 years ago

Jihwan_Kim Hello, I'm replying on behalf of Arslan. He has said:

 

Great, thanks  , the conditional formatting now works.

 

 

 

However I have just noticed my table columns have reordered into alphabetical order, any way to resolve this? 

 

Also, under each column, the same value is repeated across as per the screenshot attached. How would I fix this please?

 

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Pricey79 

Thank you for your feedback.

Please share your sample pbix file's link here, then I can try to look into it to find out the cause of the problem.

Thanks.