Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi,
I have a slicer for Geograpy with Region and Country.
I have a Matrix visual
Rows : Region Country Product
Columns : WeekInQuarter
Value : Count(Products)/SUM(Sales)
APAC | 1 | 2 | 3 | 4 | 5 | 6 | 7,8...14 | ||
JAPAN | |||||||||
CAR | 3.3% | 6% | 8% | 12% | 2% ..... | ||||
HOUSE | |||||||||
Ship | 7% | 4.6% | 2.3%.... |
The problem :
When there is no value for a product for all columns(House 1,2...14) i want to show in country the measure for the Region (all countrys not just japan)
APAC | 1 | 2 | 3 | 4 | 5 | 6 | 7,8...14 | ||
JAPAN | |||||||||
CAR | 3.3% | 6% | 8% | 12% | 2% ..... | ||||
HOUSE | 6% | 7% | 3.9% | 18% | 5% | ||||
Ship | 7% | 4.6% | 2.3%.... |
TNX
Solved! Go to Solution.
Hi @RsimonAlign ,
Not sure if I understand what is the final result you want to achieve.
When the product has no values (return of the calculation is blank) you want to replace that specific line by the calculation of all the countries?
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @RsimonAlign ,
Not sure if I understand what is the final result you want to achieve.
When the product has no values (return of the calculation is blank) you want to replace that specific line by the calculation of all the countries?
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThis is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
75 | |
68 | |
41 | |
35 |
User | Count |
---|---|
107 | |
56 | |
52 | |
48 | |
40 |