Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
HunTran
Frequent Visitor

PowerBI Matrix how to hide blank rows

Hi,

 

I have a data model that looks like this: Sales are linked to Stores by a LocationKey, also Sales are linked to RSA by an RSAKey.

HunTran_0-1692131328831.png

I need to create a matrix that shows Stores, then RSA, then the Sales$.

HunTran_1-1692131530535.pngHunTran_2-1692131567147.png

 

But because there is no direct relationship between Stores and RSA, when I drill down, all RSA will show. Is there any way that I can get rid of the blank rows?

 

(1 solution that I used before is to create Related Columns of Stores Name and RSA Name in the Sales table, and drop that in the matrix, that way it will show without blank rows, but I do not want to do Related Columns because Sales table get really big (>20Mil rows) )

 

Appreciate any insights. Thank you guys very much,

3 REPLIES 3
parry2k
Super User
Super User

@HunTran in the matrix visual image you shared, I see lot more values in that, what all are values you are using in the matrix visual?

 

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

HunTran
Frequent Visitor

The visual i am using is something like this:

Sales$ = CALCULATE(SUM(HomeStore[Sales]),DateMaster[FiscalYear] = YEAR(TODAY()))
 
Does the additional year filter affect it?
(To clarify, the LocationKey coming from Location table, RSACode coming from RSA table, not the Sales table. it works automatically if both of them come from the Sales table)
parry2k
Super User
Super User

@HunTran what measure you are using to visualize the data? It should work out of the box.

 

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.