cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Matrix Control in Power BI Service

Hello,

 

 

I have a week dimension and a sales fact in my power bi model. I created a matrix control & a week slicer to filter the matrix control, the slicer works well in the desktop version, however when I publish it to the web version it works only for records that matches with the week, if I select a week which does not exist in the fact table it shows the data for the last selected week. It changes only when I click the matrix control.

 

Power BI :Version: 2.48.4792.721 64-bit (July/2017)

 

Dimension

Week:

Columns: Week (contains week # 1-52)

Facts:

Sales:

Columns: Week, Product, Product Type, Sales Amt

 

Matrix -

Columns Product - Product Type

Values- Sales Amt

 

Relationship One to Many (Week - Sales) on Week #

3 REPLIES 3
Highlighted
Microsoft
Microsoft

Re: Matrix Control in Power BI Service

Hi @raviahuja,

 

Do you still have this issue?

 

According to your description above, I have tested it with the same version of Power BI Desktop, and then published the report to Power BI service. The filter works all fine on both Desktop and service without this issue.

 

Could you post some screenshots on what you get on Power BI service? And it's better that you could also share a sample pbix file which can reproduce the issue. So that we can help further investigate on it. You can upload it to OneDrive or Dropbox and post the link here, or sent it to me in private message. Do mask sensitive data before uploading. Smiley Happy

 

Regards

Highlighted
New Member

Re: Matrix Control in Power BI Service

Yes. the issue still persists, it occurs when I publish it to Power BI service. Here is the link to onedrive

 

https://1drv.ms/u/s!AqNMOyOjzH8wa4n_FNycczNdJJg

 

Highlighted
Microsoft
Microsoft

Re: Matrix Control in Power BI Service

Hi @raviahuja,

 

I have tested it with your shared pbix file, and the Slicer still works all fine with the Matrix visual in Power BI service on my environment.

 

Animation.gif

 

As I cannot reproduce this issue, I would suggest you create a support ticket on Power BI Support page for better assistance on the issue. Smiley Happy

 

Regards

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors