Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional formatting help - Duplicate rows for ID

Hi All,    I was wondering if someone could help me. I am having trouble with conditional formatting in Power BI and I need some assistance. My aim is so insert another column inside of the table t...
General Comment
Need Help
  • samdthompson's avatar
    samdthompson
    4 years ago

    You need to return Time as a measure. Currently thats just the rows from a table. Youll need two measures:

     

    Hours=SUM(Table1[Time])

     

    Then the conditional measure

     

    Example=SWITCH(TRUE(),[Time]=60,1,[Time]=30,0.5,0)

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi samdthompson , thank you for the logic. 

I have an issue with this though I am unable to use the EXAMPLE measure on more then 2 occasions before it freaks out. 

The larget number in the HOURS2 column is 2370 but using what you provided to me I am unable to make it work with more values. 

 

I would like to show 0 for all values that are 15 mins or less. 

I would like to show 0.5 for all values that are >=16 but less than <=45 

I would like to show 1 for all values that are >=46 but less than <=75

 

Example1 = SWITCH(TRUE(),[Hours2] <= 45,0.5 ,[Hours2] >= 16,0.5,[Hours2] <= 15,0)

 

The result I get is this - 

 

 

but when I use only 2 values I get this - Which is working

 

Can you show me how I would write more then 2 values please

 

thanks