Forum Discussion
Bar Chart colour based on Table
Hi, I have a Table showing what versions of software are approved and a Bar Chart showingwhat is actually installed on the user's device. I would like to change the colour of this bar to get it t...
HI Anonymous,
Maybe you can try to use the following measure formula on data color formatting to highlight the records that existed in your Approved Software Versions tables:
Measure = VAR selected = ALLSELECTED ( 'Approved Software Versions'[iOS] ) VAR currVersion = SELECTEDVALUE ( 'Purchased App Versions'[iOS Version] ) RETURN IF ( currVersion IN selected, "Red", "Blue" )Regards,
Xiaoxin Sheng
HI Anonymous,
Maybe you can try to use the following measure formula on data color formatting to highlight the records that existed in your Approved Software Versions tables:
Measure =
VAR selected =
ALLSELECTED ( 'Approved Software Versions'[iOS] )
VAR currVersion =
SELECTEDVALUE ( 'Purchased App Versions'[iOS Version] )
RETURN
IF ( currVersion IN selected, "Red", "Blue" )
Regards,
Xiaoxin Sheng
Hi Anonymous - Thank you so much for your help with this, this is exactly what I was after!