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
Option to set custom width for gridlines OR fixed outer padding
When designing reports, using the align and distribute evenly options in the format pane are useful, however when designing report pages with fixed bleeds between visuals I have to follow these steps...IolaWhiteley4 hours agoAdvocate IINew2Views0likes0CommentsDefault Scrollable Time-Series Charts to Most Recent Data
Currently, Power BI time-series charts always open scrolled to the earliest (leftmost) date by default, which is inconvenient for reports where users are interested in the most recent (rightmost) dat...CStillwell5 hours agoNew MemberNew21Views2likes1CommentOption to Stop Fabric Planning Billing Session After Plan Item Deletion
Currently, a Fabric Planning session remains active for 30 days once triggered. If a user creates a Plan item only for testing and deletes it the next day, the billing session still continues and c...v-dugumarrir16 hours agoMicrosoft EmployeeNew44Views10likes1Comment