Forum Discussion
Use Parameter value to conditionally format bar chart
How can I use the parameter value to conditionally format a bar chart? I am able to use the following formula to color the bar chart in the way I want -
Hi mtdewrocks
You can use a numeric parameter for the desired result.
1. Add parameter
2. create a flag measure with the needed condition (using the parameter measure that you will have after creating the parameter):
color flag = if('Parameter'[Parameter Value]=[count_companies],1,0)3. use conditional formatting based on the flag measure
Result :
Pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
4 Replies
Hi mtdewrocks
You can use a numeric parameter for the desired result.
1. Add parameter
2. create a flag measure with the needed condition (using the parameter measure that you will have after creating the parameter):
color flag = if('Parameter'[Parameter Value]=[count_companies],1,0)3. use conditional formatting based on the flag measure
Result :
Pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
Your response is essentially what I tried. However, I am working with a column chart, and it still seems to be aggregating my column so all values are returning true, even when not. Sorry for being so new to the community, but can you assist with how to attach my pbix file? If so, I'm sure that would help troubleshoot.
Yes, without pbix it is very difficult to guess what you are trying to do and where the problem is.
How do I upload my pbix file to you? I don't see the button or know how.
