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 l...
Need Help
Tips and Tricks
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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi,

        Thanks for the quick replay, please find the attached PBI pictures (I can't share the file):