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
- Koustav_BagNew Member
Hi I am unable to apply Conditional Formatting enable on Field parameters. Please look into this
- fbcideas_migusrNew MemberStatus added:New
- v-mtsurusawaNew Member
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.
- fbcideas_migusrNew MemberStatus added:New
- jeroenterheerdt
Microsoft Employee
Status changed:NewtoNeeds Votes
- matt_calvertNew Member
Fields parameters need the same formatting options as bookmarks like being able to change the fill if you hover over a selection.
- fbcideas_migusrNew MemberStatus added:New
- michael_hall1New Member
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.
- fbcideas_migusrNew MemberStatus added:New
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Dynamic Labels for Subtotals and Totals in Power BI Matrices
Power BI should support dynamic expressions for subtotal and total labels in Matrix visuals. Currently, subtotal labels are static, which limits report usability and forces report authors to implemen...KellyMc4 hours agoNew MemberNew6Views0likes0CommentsCustom page navigation and foldable menus with less bookmarks (modern web UI inspired)
I recently watched a lot tutorials on how to achieve page navigations as common in modern web frameworks as Bootstrap including foldable site menusbars and dropdown menus. Or building toggle buttons....Famondir5 hours agoNew MemberNew96Views1like1CommentNavigation page - create custom sections and heirarchy
Please can you bring back this feature? https://powerbi.microsoft.com/en-us/blog/designing-custom-navigation-for-power-bi-apps-is-now-available/ We have many reports in our app, and would like ...anna_schorfield5 hours agoNew MemberNew109Views1like2Comments