I need to have the possibility to add conditional formatting in Matrix chart as we can do in Cross table in Excel. Thanks
40 Comments
- nishalitNew MemberWe've added support for conditional formatting on the matrix visual in the November release of Power BI Desktop. To learn more, check out our blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-feature-summary/
- JUSANGNew MemberI have the same requirement. For each cell in matrix, I can format it by condition like we do in excel pivot table.
- chrisho
Advocate I
Would be great if this is available for Multi-row card. There should be an option for coloring the bar base on a field's value. - mikejarodNew MemberKim said: "Conditional formatting is already available on the table visual" That's entirely true, but only per (1) column and that column must have an aggregration/summarization (sum avg etc). It does not work for "do not summarize" values. It should also be possible to format an entire row in a table based on the value of 1 cell / column. Tables and matrices should behave almost identical whenever possible.
- jschlereth21New MemberYes, a heat map (conditional formatting) component in the matrix table would be great.
- ckhachatrianNew MemberThat'll be great. Can't wait to see this happen in matrices as well. Our report consumers just love the conditional formatting in the table grid but we would be better served with a matrix. Thank you
- vincent_j_kokNew MemberKim Are you also adding the option to make a risk matrix? With colloring options? Green for low impact and low risk to red for high impact and high risk? That would be great!
- fbcideas_migusrNew MemberThis is a good idea, although again much of what is going on here seems to be bringing Power BI in line with Excel - or rather with a baseline set of features people use in Excel. At some point I hope it occurs to someone that convergence may make more sense than duplication.
- JorgeDiaz
Advocate I
We need conditional formatting based on field but to be applied on entire ROW. - fbcideas_migusrNew MemberThanks, One more suggestions / ask for the matrix and table visual is to allow them to act as filters, similar to what for example a tree map does. It will be great to see a matrix visual with conditional formatting that can also act as a 2-D filter. E.g. when you select a cell, the category for the row and column in other charts are cross filtered as well.
Recent ideas
Native SAP SuccessFactors and Active Directory Connectivity for Simplified Data Integration
Having native connectors for SAP SuccessFactors and Active Directory would eliminate the need for workarounds such as notebooks, custom scripts, or complex integration setups. Users should be able...João_Cristo22 minutes agoNew MemberNew2Views0likes0CommentsAllow Azure Databricks streaming tables to be mirrored into Fabric
Mirroring an Azure Databricks Unity Catalog into Fabric silently drops streaming tables. They are not greyed out, not flagged, not explained. They simply do not appear in the picker, so there is no w..._taab1 hour agoNew MemberNew5Views0likes0CommentsPower BI, import report and semantic model: show change connection pop-up
When you need to import an existing Power BI report and semantic model in Tenant B that's created in Tenant A, you need to jump through a number of hoops to fix the original connection. It's doable, ...Reitse2 hours agoMost Valuable ProfessionalNew6Views1like0CommentsEnable per-user security for shared gateway connections using service accounts
When a shared gateway connection uses a highly privileged service account, all source queries run with that account’s permissions. Users cannot see the stored credentials, but report developers who c...AshishChougala3 hours agoMicrosoft EmployeeNew10Views6likes0CommentsRequest to add a feature to extract gateway connection status and last time credentials used
Could you please add a feature in the admin UI on Microsoft Fabric/Power BI to extract the Gateway connections with details of the gateway connection status and last activity information along with t...Vinodkumar_Chak4 hours agoNew MemberNew23Views1like0Comments