Forum Discussion

Kolumam's avatar
Kolumam
Post Prodigy
8 years ago

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 cli...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

Kolumam's avatar
Kolumam
Post Prodigy
8 years ago

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 ?

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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