cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

Problem with filtering data

I have a bar chart which shows "signed projects" and "newly operational in month" for every month. When I click on Signed projects it is able to filter the table and gives a breakdown, but when I click on Newly operational in month it goes blank.

 

See the attached screenshots.

Capture.PNG

 

When I click on Signed in Month the below table is filtered for that particular month. For example Sep 2017

 

sd.PNG

 

When I click on "Newly Operation in Month"....actually I am not even able to click it. so When I try to click on this, it shows the same but for sep it is supposed to show 0 and for Nov it should show just 0.7 (from the first table)

 

I checked the relationships but it exists. Please help. Thanks.

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Problem with filtering data

HI @Kolumam,

 

I'm not so clarity "newly operational in month" means, is it a measure or one legend?
If measure, current power bi not support use measure as the filter.
If legend, I think you need to check on your relationship mapping and settings.

 

BTW, it will be help if you share some sample data for test.

Notice: if your contents contain any privacy data, please do mask sensitive data before sharing.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Highlighted
Post Prodigy
Post Prodigy

Re: Problem with filtering data

Hi v-shex-msft,

 

If what you're saying is true, how come it is able to filter "Signed in Month" which is also a measure. 

 

Signed in Month  - Measure

Newly Operational in Month - Measure

 

It has sensitive data which I am not supposed to share. Are you in Skype ?

 

 

Highlighted
Community Support
Community Support

Re: Problem with filtering data

HI @Kolumam,

 

When you click on chart which has multiple measures as value fields, other visuals not filtered by measure.
Actual, power bi will use the axis label as filter parameter.

 

>>It has sensitive data which I am not supposed to share.

Maybe you can try to create a sample with some fake data, similar relationship and table structure.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Highlighted
Advocate III
Advocate III

Re: Problem with filtering data

HI @Kolumam,

I think you need to check if you are calculating the newly operational in month with a measure or is a column?

If that is the case then. Is the measure linked to another table? if yes then check the relationships and how is connected. The automatic relationships are not always right. 
If not check that the data are correctly format or if there is data hole in those months. 

I hope that helps, otherwise, you can always share a sample data set as suggested by @v-shex-msft.

Best,
J.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (894)