Thanks for the video! I like Patrick's solution better because it's more maintainble to have the color values in a measure rather than buried in each formatting dialog box.
100% I moved to a different workplace and don't have the same set of tools that I would normally use... Power BI is one of the few things that I have available. I really appreciate the power that's under the hood... but it can be so tediousness when you're working on a complex set of transformations only to realize you've gone down the wrong path to your solution and have to rewrite a bunch of stuff... I'm getting RSI on my mouse hand wishing I could open the entire project in VS Code and do a regex find replace
Excellent video! I was faced with this same question a few weeks ago. I went the DAX route, but wrote a switch statement like this: Table Metric (Conditional Formatting) = SWITCH( SELECTEDVALUE('Table Metric'[Table Metric Fields]), "'Metrics'[Metric A]", FORMAT('Metrics'[Metric A], "###,###"), "'Metrics'[Metric B - %]", FORMAT('Metrics'[Metric B - %], "##.#%"), "'Metrics'[Metric C]", FORMAT('Metrics'[Metric C], "###,###") ) Note that I wrapped the Switch values in double quotes. I typed the metric names using intellisense, then added the quotes to all 3 lines at the end. This Table Metric (Conditional Formatting) replaces the field parameter and goes into the values well of my matrix, and I have everything that I wanted. The numbers are formatted appropriately (as percentages or whole numbers), and there is conditional formatting of the metric values. The one downside is that I needed to select one specific measure to conditionally format the table, regardless of which measure was selected. The benefit, compared to this method, is that it allows use of all of the standard conditional formatting options, including gradient conditional formatting. I love your videos and thank you for keeping us up to date and for sharing your incredible knowledge! Cheers!
Thanks for the video! I would use DAX because "real developers" use DAX. Of course, I'm kidding. I would lean toward DAX because I'm learning it and I like writing code.
Thanks for the video, Adam! I was wondering, is there a way we could use SELECTEDMEASURE() function to dynamically select measures and get different colors for conditional formatting. E.g, SELECTEDMEASURE () > 0 , "Green".
I had an issue doing conditional formatting on a field parameter that is used for the rows or columns in a table. But I found that if you add that field to the table manually, set conditional formatting then remove the field (since it's contained in the field parameter), the conditional formatting remains on that columns included in the field parameter.
I'm trying to make this work on my visual, but I have a dynamic X and Y axis and I believe my other dynamic axis is kind of blocking the DAX from working properly. Any assistance would be appreciated!
thanks for this video it is very helpful.... I also have a question I have a power bi report in which I am using multiple datasets and report being refresh in every 15 minutes..... but some of datasets not being update in every 15 minutes so if it is possible to refresh those dataset in different frequency and the dataset updates in every 15 minutes refresh in every 15 minutes.
Q: i have a similar problem, pls help. In my value, I have my field parameter. (Total sales of current week, past week, etc). So one measure being field parameter. Then on my bar graph axis, i have my products. However i want to not only highlight current week but different color for each product. How to do this ??
There’s a hack here. If you want to use the standard PBI conditional formatting.. add the original measure (that you want to format) from your model to your visual alongside your parameter, add your conditional formatting to the measure, then remove the measure from your visual.. you’ll find it sticks when using it in the field parameter too :)
that works only when you don't change the measures given to the visual, for example if I have a bar chart that uses a field parameters to remove or add bars, the colors get reset everytime you add or remove a measure...
Hello, I have a very important question, I am currently putting together a dashboard and I have two different matrices, one that reflects the sales of last year and one of the current one, I need that if the value of the current matrix has higher values than the previous one, it is green. , otherwise it is red, the problem is that the value field is not a table, it is a measure created that talks about the DispatchRatePercent. How could I do this with conditional formatting
Hi, i need some help on how to conditional format on multi kpi card? I know we can use conditional formatting on normal card. Would be helpful if someone can help
I figure this out recently too. However I was wondering how to take this further. Support you want different visuals for various FP listed in the slicer, how can this be achieved. So far I though if having multiple FP with synch slicer somehow. You might want bar chart for some items in the slicer list or line graph for others?
Yours, but I would look for other ways of visualizing this instead. I can't imagine having to do this for each selection, especially if I rely so heavily on filtering via other visuals..
Thank you for the video. Would it be possible to have a different conditional formatting but for the same measure? I would need to differentiate the measure's background color over time (selected field would be Q1, Q2, Q3 and Q4). If anyone could assist, I would be soooo happy.
To calculate the percentages in a table or matrix, SWITCH and ISINSCOPE were used, but now the field parameters (which users can set the number they want and in the order they want) how can it be calculated so that the result is correct when the user adds, deletes and changes the order of the field parameters?
You absolutely rock !! I did have the idea to look in the visual itself but couldn't see an option so headed off to bed (was working late). Then i saw this video and got up again and went back to work. 2 beautiful solutions, I prefer the clicky version. Thanks guys !!
hey so I know it's been a year already but I just noticed that the dax code in the video doesn't work. You may notice that the values that should be formatted the same color are not. This is because ISSELECTEDMEASURE returns false which makes the entire thing default to _tq.
I might go with Patrick's way because I need to display one selection as 'thousands' and another as numbers - say, Invoice Amount and Client Count. And this is for a VISUAL. I can do that with conditional formatting within the table, interestingly enough.
Your videos are excellent, guys! Congratulations!!! I'm still a beginner in DAX and I feel I could accomplish my goal if I do something slightly different. Let me explain... I have 3 Field Parameters (Revenue, Cost, and Gross Profit) and 1 bar chart where the user may see 3, 2, or 1 of the measures. I want to color the bar according to the parameter chosen. For example, if the user selects Revenue, make the bars green, if the user selects Cost, make the bar orange, otherwise (Gross Profit) make it blue. Could someone help me, please?
