AaronSch
Advocate I
8 years agoStatus:
Needs Votes
Matrix Conditional Formatting Rules to include other field values as criteria
I really like the conditional formatting rules, however I would like to also be able to conditionally format a said value in a different colour / range dependent upon other fields values. eg A sale Margin of 30% on Product A may be green but on Product B (a much more profitable item) a green may not kick in until 45%, so when I've applied a filter to look at my matrix for only Product Bs and not Product As, I am needing a different rule to be applied to the conditional formatting colours etc.
2 Comments
- fbcideas_migusrNew MemberThis is an important feature. In our medical example, the success of a measure is not simply based on the value of that measure. We have a complex DAX algorithm that determines other context around the score to determine pass or fail. We need to use that separate field. If we could select that field in advanced before applying ranges, that would work.
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Make workspace and item session persistence optional
Description The new persistent session behavior in Microsoft Fabric should be optional rather than forced. Currently, Fabric remembers the workspaces and items that were open in my previous session...TeemuMultanen30 minutes agoAdvocate INew287Views47likes2CommentsSupport Encrypted Sensitivity-Labeled Excel Files in Power Query
Description Currently, Power Query Online and Power Query in Excel are unable to access encrypted Excel files. Excel files with sensitivity types other than Public or Non-Business can be encrypted a...ewarstdhyjugkhi1 hour agoMicrosoft EmployeeNew14Views6likes0CommentsAuto-propagate Lakehouse (Direct Lake) permissions to users assigned to a Power BI App audience
Problem When a Power BI report uses a Live Connection to a Direct Lake Semantic Model, end users must have explicit ReadAll / ReadData permissions on the underlying Lakehouse (or its SQL analytics e...majofv3 hours agoNew MemberNew5Views1like0Comments