For a single column you can use the below measure to be applied to the conditional formatting if you have a calculated item called MoM % and want to apply it to the measure total sales. One Measure Cond Format = IF( SELECTEDVALUE('Select Period'[Period]) IN {"MoM %"}, [Total Sales], BLANK() ) There's a bit more to it for field parameters so I'll do a quick video over the next week to explain in more detail as it's hard to cover all in a comment with visual aids 😀
Hello ! Good, thank you for this vidéo (y) Well, what about formating measures in calculation group with colors for example ? like the first table with multiple measures
There is an easy work around to losing the sorting ordinality when using Field Parameters and Calculation Groups. Interestingly the default in Power BI when a Sort By Item is selected is Descending, but if you lose the sort item, which you do with Calculation Groups and Field Parameters, the default sort order becomes Ascending. So you could change the ordinality in Tabular Editor to 1 instead of -1, or you can solve it with a calculated sort column. Most people have a serial column for week, month and quarter, and years are already an ascending serial number. SO, to Solve this very problem in our tables and matrixes, we created a "sort by column" which simply multiplies the serial month, week, quarter, or the year by -1. This will create an opposing directional serial listing that can then be used as a sort order for the Week, Month, quarter or year. CRITICAL: Do not select a Sort By Item on the visual, and the problem is solved. If you need to switch directions, simply change the sort order for your date TABLE columns to be by the serial number instead of the negative serial number. Simple but it works.
Can you go over on how to do conditional formatting to these columns, such as if you just wanted to format % column and not the MoM column
For a single column you can use the below measure to be applied to the conditional formatting if you have a calculated item called MoM % and want to apply it to the measure total sales.
One Measure Cond Format =
IF(
SELECTEDVALUE('Select Period'[Period]) IN {"MoM %"},
[Total Sales],
BLANK()
)
There's a bit more to it for field parameters so I'll do a quick video over the next week to explain in more detail as it's hard to cover all in a comment with visual aids 😀
I have published a video that covers this now 🙂 ua-cam.com/video/MbxJ1oHHyTg/v-deo.html
Hello ! Good, thank you for this vidéo (y)
Well, what about formating measures in calculation group with colors for example ? like the first table with multiple measures
Hey, I covered that in a later video ua-cam.com/video/MbxJ1oHHyTg/v-deo.html
There is an easy work around to losing the sorting ordinality when using Field Parameters and Calculation Groups.
Interestingly the default in Power BI when a Sort By Item is selected is Descending, but if you lose the sort item, which you do with Calculation Groups and Field Parameters, the default sort order becomes Ascending. So you could change the ordinality in Tabular Editor to 1 instead of -1, or you can solve it with a calculated sort column. Most people have a serial column for week, month and quarter, and years are already an ascending serial number.
SO, to Solve this very problem in our tables and matrixes, we created a "sort by column" which simply multiplies the serial month, week, quarter, or the year by -1. This will create an opposing directional serial listing that can then be used as a sort order for the Week, Month, quarter or year.
CRITICAL: Do not select a Sort By Item on the visual, and the problem is solved. If you need to switch directions, simply change the sort order for your date TABLE columns to be by the serial number instead of the negative serial number. Simple but it works.