Field Parameters AND (Conditional Formatting OR Influencer Visual)

[Schmidtmayer]

Hello 😃

I am really thrilled by the new field parameter feature 😃 But, there are some things I lack compared to a more traditional approach using calculation, for example via numeric parameters.

First: Whenever I put columns and measures within a field parameter, I simply cannot finde the option to define conditional formatting. Is this actually possible? No matter if DAX or something else.
For example: We do measure illness quotas and productivity quotas within our company and there are predefined targets for those. So, in case, illness quota is selected for display in a table, the column illness quota should use conditional formatting, same for productivity quotas.

Secondly:
In case I wanna use field parameters for the influencer visual (one just containing measures for Analyze, one containing measures and columns for Explain By), there is an error message, saying there is a missing connection between for a table, namely the newly created table for the field parameters for the measures. Any way, this can be circumvented?

[ross27]

I've not checked if this applies to other visuals yet, but with the Table visual I've just noticed you can apply conditional formatting to your field parameter under the Cell elements formatting section.  You have to specify the formatting for each value in your parameter which provides extra flexibility and, I guess, explains why the option doesn't appear in the context menu.

[Anonymous]

Hello @Schmidtmayer ,
It is possible to do conditional formatting based on field parameter. For example I have field parameter full of measures. I created a new measure for conditional formatting based on field parameter table created: 

Conditional Formatting =

SWITCH(

SELECTEDVALUE( 'Field parameter'[Field parameter Fields] ),

" 'Measures'[Sales Revenue] ", 'Measures'[Sales Revenue] )

Now you can select your column, line or icon color based on a measure you just created. You just go on "format your visual" - page and there you have different options for formatting your visual. I hope this helps someone if not you directly.

[Anonymous]

this is genius 👍

[Anonymous · Accepted solution]

Hi @Schmidtmayer ,

For your first problem, Yes. The conditional formatting option will not display when you apply the field parameter in Values field... And I'm afraid that there is no other method to make conditional formatting....

For the second problem, could you please provide the related screenshot with error message? How did you set your influencer visual? If the visual involves the fields from multiple tables, please provide the relationship info if any relationship created.

Create key influencers visualizations

Limitations

Best Regards