Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 Blank values replace Zero.
Expected Output.
Solved! Go to Solution.
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
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
Hi,
There is the same solve issue in the community, Please have a look :
https://community.powerbi.com/t5/Desktop/Replacing-null-values-in-matrix-visual/td-p/1019736
Appreciate your Kudos and please mark it as a solution if it helps
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |