RCeballos's avatar
RCeballos
New Member
4 years ago
Status:
New

Field Parameter conditional formating

The new field parameter is very helpful but also limiting. Previously I did the same thing by creating an extra table and using a switch dax measure. This method is faster but more limiting. I can not add it to conditional formatting. I am forced to keep using the old method! Please enable using the field parameter in conditional formatting

10 Comments

  • Hi I am unable to apply Conditional Formatting enable on Field parameters. Please look into this

  • In the future, we would like to see the introduction of a function that allows conditional formatting with field parameters.

    Currently, conditional formatting is only available for table and matrix visualizations, which we feel does not allow for a wide range of expressiveness in reports.

  • Fields parameters need the same formatting options as bookmarks like being able to change the fill if you hover over a selection.

  • Field Parameters are a fantastic new tool, and we can apply conditional formatting on tables per parameter (a little laborious doing it for each parameter, but we have it, which is what really matters). However, we can't do this, for example, for column colours in a column chart visual. This would be a really useful way to quickly parse information using colour.


    Let's say the measures in your field parameters were data 1, data 2 and data 3.

    -Data 1 has a target of 1% (green below 1% and red above 1%)

    -Data 2 has a target of 0.25% and a max of 3% (so green below 0.25%, yellow between 0.25% and red above 3%)

    -Data 3 a target of 30% (green below 30% and red above 30%).

    You can't currently, using conditional formatting of column colour and field parameters, get different conditional formatting based on which field parameter is active in the slicer e.g. have data 1's targets active when data 1 is selected, and data 2's targets active when data 2 is selected. You are currently stuck with only using one measure as the basis for conditional formatting for the visual, no matter what is selected in the field parameter slicer.

Recent ideas