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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
eric98
Helper II
Helper II

Barcode Filter doesn't work

Hello everybody, hope you're well.

I'm facing an issue and I hope you will be able to help me.

I have two reports on Power BI Desktop that I pushed in the Power BI service. The two reports have their own datasets and both of them have a column categorized like Barcodes in their own datasets. I'm doing all that because I want to be able to scan a barcode with my phone camera with the Power BI Mobile App, and have all the data with the barcode as filter.

It's work for the first report but not with the second.

I'm wondering if it is not because the first report doesn't have any filter and the second one has several.

Also, in the second report, I have a measure, I don't know if it can be the reason.

1 ACCEPTED SOLUTION

Hello, 

I'm glad to inform you that I've found the solution of my problem.

The filter doesn't work on my second report because I didn't correctly make the relations between the tables that I have.

 

Thank you very much for your help.

View solution in original post

4 REPLIES 4
eric98
Helper II
Helper II

From the home page or from the footer of the report, I have the same result.

The first report filter normally the visuals, but the second one don't. I only have the visuals like they was before filtering.

Below some screenshoots

 

First report before filtering

First report before filteringFirst report before filtering

 

 

First report afterfiltering

 

First report after filteringFirst report after filtering

 

Second report before filtering

 

Second report before filteringSecond report before filtering

 

 

 

Second report after filtering

Second report after filteringSecond report after filtering

 

And the two reports are in the same application

Thanks @eric98 ,

Can you please make sure that your report dataset includes only one table with barcode column and that this is the one you used in the report?

It will also help if you can send us your PBIX, you can send it to the following email:

Is it possible for you to share a recording for the scenario?

and send it to the following email address?
mpbisup@microsodt.com

 

Thanks,

Michal

 

Hello, 

I'm glad to inform you that I've found the solution of my problem.

The filter doesn't work on my second report because I didn't correctly make the relations between the tables that I have.

 

Thank you very much for your help.

michalfoster
Power BI Team
Power BI Team

Hi @eric98 ,

 

 

We couldn’t reproduce this issue on our environment ,can you please provide additional information?

  • Did you scan from the Home page ore from the report footer?
  • When you say it didn’t work what exactly didn’t work?
    • You didn’t saw the report in the list
    • You got an error that the report could not be filtered?
    • You didn’t notice any filtering on the report after scanning?
  • Does the report was filtered on barcode before scanning?

 

If you can provide screenshots that will help us to understand the scenario or share the pbix

 

Thanks,

Michal

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors