0 Kudos

Page level filter + interaction filter issue

Status: New
by Arklur Regular Visitor on ‎12-11-2018 10:20 PM

First I'll try my best to explain the issue, I made a simplified version of the report I have problem with.

 

I have 2 visuals on my riport, a table and a pie chart, both using the same and only table.

Currently there are no filters on the page. If I select the first row of the table, on the pie chart I see the corresponding data to that row, just as expected, so far so good.

But if I filter out one of the codes (but not the BI), the pie chart shows nothing:

 

 

This already doesn't make sense to me, I'm filtering out records with the "FESZDWPOSTINSTALL" code and selecting the "BI" from the table. But let's not stop here. Currently the "interaction" from the table to the pie chart is set to "filter", not "highlight". If I change it back, it works:

 

Even better: if I remove the last column from the table, change the interaction to "filter", it still works:

 

I have no idea what's going on Smiley Sad. Can you help me out? Unfortunately I'm using SSAS as a source so I can't really provide the source data for the report.

 

Thanks for the answer/help in advance.

Comments
by Moderator v-qiuyu-msft
on ‎12-12-2018 10:08 PM

Hi @Arklur,

 

I'm not able to reproduce the issue on my side. Would you please update your Power BI desktop to the same version 2.65.5313.621 64-bit (December 2018) as ours then test it again? 

 

Best Regards,
Qiuyun Yu 

by Arklur Regular Visitor
on ‎12-17-2018 11:14 AM

Hi @v-qiuyu-msft,

 

Sorry for not responding for a long time, it was a busy week. I'm actually using the Report Server version of the desktop (and the Report Server itself - I mean, the issue is not just happening in the desktop, but after I publish it to the RS and check the report there). I'm using the latest version of these products.

by Moderator v-qiuyu-msft
on ‎12-19-2018 12:09 AM

Hi @Arklur,

 

I have tested in Power BI desktop optimized for report server 2.61.5192.641 64-bit (August 2018) and report server version 15.0.2.557, still not able to reproduce the issue. Please check if my steps is correct. 

 

 

Best Regards,
Qiuyun Yu 

by Arklur Regular Visitor
on ‎12-19-2018 12:14 AM

The steps are indeed correct. If I'll have time, I'll try to make an imported version of my report (currently it's using SSAS Live Connection), and first see whether it works or not, if it doesn't, I'll send the file to you.

Thanks for replying.

(As for my other "bug report", I also tend to send the file to you, but first I have to mask the data, which will only happen likely next year...Happy Holidays in advance Smiley Happy)

by Moderator v-qiuyu-msft
on ‎12-19-2018 10:17 PM

Hi @Arklur,

 

You can upload the file to your OneDrive and send the share link to me via private message. 

 

Hope you will have good holidays too. Smiley Happy

 

Best Regards,
Qiuyun Yu 

Idea Statuses