Forum Discussion
Dynamic bar color
Using the same disconnected table but with the logic in the measure reversed
Disconnected Total Revenue = CALCULATE ( [Total Revenue], TREATAS ( VALUES ( 'Disconnected Category'[Category] ), Category[Category] ) ) Disconnected Conditional Bar Color = IF ( SELECTEDVALUE ( 'Disconnected Category'[Category] ) IN VALUES ( Category[Category] ) && ISFILTERED ( Category ), "red" )Please see the attached pbix
It is possible but you need to create a separated table to make this work
Can you share the pbix via some cloud service? Otherwise I give you a path to follow
If this helped, please consider giving kudos and mark as a solution
mein replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Here is the path
1 create a new table
Selection = ALLNOBLANKROW ( Table[column] )
where Table[Column] is the column where you have the values "Finance and audit", etc
Leave the new table disconnected ftomr the model
2 create the following measure
SELECTEDVALUE( Table[column] ) =
SELECTEDVALUE( Selection[column]),
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI