Forum Discussion

Shanvitha_V's avatar
Shanvitha_V
Frequent Visitor
3 years ago
Solved

Matrix value No Empty

HI Export below my input     I have tried my Power BI report using Matrix below like my problem is Jan-22 IND is blank(NO values in source table) Feb-22 USA is BLank I need where ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Shanvitha_V ,

    I created a sample pbix file(see the attachment) for you, please check whether that is what you want.

    1. Create a country dimension table using below formula

    Countries = VALUES('Table'[Country])

    2. Create a measure as below:

    Measure = SUM('Table'[Amount])+0

    3. Create a matrix visual as below(Rows:  field [Month Year]  Columns:  field [Country] of the country dimension table  Values: new measure)

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Shanvitha_V ,

I created a sample pbix file(see the attachment) for you, please check whether that is what you want.

1. Create a country dimension table using below formula

Countries = VALUES('Table'[Country])

2. Create a measure as below:

Measure = SUM('Table'[Amount])+0

3. Create a matrix visual as below(Rows:  field [Month Year]  Columns:  field [Country] of the country dimension table  Values: new measure)

Best Regards