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

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, ArslanManzoor 

I am not sure how your real data model looks like, but in my opinion, if your table 1 and table 2 has the same table structure as above, then, you can open my pbix file and replace the data with yours. If the date range is larger, then you need to fix the calendar table and axis table to include your date range.

If it is OK with you, please share your table1 and table2, then I can try to look into it to come up with a more accurate solution.

Thank you.

ArslanManzoor's avatar
ArslanManzoor
Frequent Visitor
5 years ago

Thanks Jihwan_Kim , I have managed to get the table to work for my data. 

Is there a solution for my conditional formatting question above I can use in this table?

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    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