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

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