Forum Discussion

nadanur's avatar
nadanur
Frequent Visitor
4 months ago
Solved

How to get the conditional formatting for missing combinations

Hello, I am new to Power BI and would really appreciate your help in solving this issue.   I am trying to add conditional formatting to the values in my matrix.   The problem is I am unable to g...
Need Help
  • danextian's avatar
    danextian
    4 months ago

    Hi nadanur 

    Power BI cannot apply values - to records that do not exist or to blank entries. A possible workaround is to use separate dimension tables for both row and column categories and assign a value within a measure (usually a zero) when blanks are returned. However, this introduces another issue: it may display values in row/column intersections that should not exist under the current filter context.

     

    Please see the attached pbix.

     

nadanur's avatar
nadanur
Frequent Visitor
4 months ago

Thank You!

Can you help me understand like i explained in my new comment on how do i know what data should go in fact and what goes in dim ?

Gabry's avatar
Gabry
Super User
4 months ago

Sure:

The core distinction

Fact tables store:

  • Things that happen (events, transactions)
  • Numeric values you want to analyze (sales amount, quantity, revenue)
  • Foreign keys pointing to dimensions

Dimension tables store:

  • Descriptive attributes (who, what, where, when, how)
  • Text, categories, labels
  • Data used for filtering, grouping, slicing

Take a look at this great piece of microsoft learn

https://learn.microsoft.com/it-it/power-bi/guidance/star-schema

it's well explained