Forum Discussion
Dynamic Color Formatting with Field Parameters
Hi minhthemeanie -Your approach with the DAX measure to handle dynamic metrics is correct, but there might be some issues with how you're applying it in the gradient color formatting.
can you check the measure Selected Metric correctly returns values based on the selected metric. You can test it by placing it in a table or card visual to verify the output.
In the Conditional Formatting set the "Based on field" to your Selected Metric measure.configure your color gradient settings.
Now try dynamically apply gradient color formatting based on the selected metric in your column chart visual.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
I dont really understand your approach for testing this out but here goes the table for my data, the conditional formatting does not really correspond with the column chart, since each of the columns represents one value from the metric?
Hi minhthemeanie ，
Try using bookmarks to toggle the visibility of the three visuals, as well as conditional formatting:Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
I have thought of it in the first place. Yet, it would make the visual processing slower to a certain extent while I am actually trying to optimize it. Thanks for your suggestion anyway!