Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Table visualization - Q&A

Hi all,

I have this table below:

I performed conditional formatting with number to highlight the status level (by converting the string into an intger fit to every status).

I would like to know if there is a way to give additional conditional formmating  for the sections before the current status level & add spaces between every row- it's should looks like this:

 

 

Thanks in advanced!

 

BR.



Need Help
Tips and Tricks

4 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

     

    Status measure : =
    IF (
    HASONEVALUE ( Tasks[Task] ) && HASONEVALUE ( 'Status'[Status] ),
    COALESCE ( SELECTEDVALUE ( Data[Status] ), "" )
    )
     
     
    Status flag : =
    VAR _indexnumber =
    CALCULATE ( MAXX ( Data, RELATED ( 'Status'[Index] ) ), ALL ( 'Status' ) )
    VAR _selectedindexnumber =
    SELECTEDVALUE ( 'Status'[Index] )
    RETURN
    SWITCH (
    TRUE (),
    _selectedindexnumber < _indexnumber, 1,
    _selectedindexnumber = _indexnumber, 9,
    BLANK ()
    )
     
     
     
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi,

      I see that you divided the data model into 3 table - however I want to perform that by only 1 table - can I do it?

      Thanks a lot!

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Super User
        5 years ago

        I failed to make those into one table.

        If you have one table for the above, please provide it. Then, I can try to use that one table to create the same result.

        Thanks.