Table visualization - Q&A

[Anonymous]

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.

[Jihwan_Kim]

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 ()

)

Link to the sample PBIX file 

[Anonymous]

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]

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]

Hi,

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