Forum Discussion

amsrivastavaa's avatar
amsrivastavaa
Helper III
3 years ago

Filter Power BI data based on Selected filter range value

Hi Folks!! I have table data as below    Project Type Year Measure P-1 A 2017 100 P-1 A 2017 50 P-1 A 2017 10 P-1 A 2018 20 P-1 A 2018 55 P-1 A 2019 75 ...
Need Help
amsrivastavaa's avatar
amsrivastavaa
Helper III
3 years ago

Hi Ashish,

 

Please share your email id as I am not getting any option to attach file here in Power BI Community page.

 

Also, I have official One drive where I am not allowed to share file with outside organization.

 

My Email Id : [email protected]

 

Thanks

Amit Srivastava

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Upload your file to Google Drive and share the download link here.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      3 years ago

      Hi,

      You may download my PBI file from here.

      Hope this helps.

      • amsrivastavaa's avatar
        amsrivastavaa
        Helper III
        3 years ago

        Hi Ashish,

        Thanks for the reply.

        I have gone through your PBI and below are my findings

         

        Bucket Filter : When I have selected <25% in bucket filter, its not filtering table properly, even records those having more than 25% are qualifying for this filter which is not correct, as an example. In snapshot (which you have provided), Project =P-3 with amount =50 must not be part of the result set but it coming as a part of result set, please help.

         

        My ultimate requirement is when user selects Bucket <25%, then table will have only those records where % of amount with total amount (Amount/Total Amount) is less than <25%, and once will have this dataset, then need to display summarized report via Matrix report (i.e. Matrix report will built on only data which is available after applying Bucket<25% filter), layout of report looks somewhat similar to the below (numbers shown are dummy records).

         

                             

         

        Can understand, as logic you suggested is based on row to row basis so it will not work on summarized data, can you please help me how to do it in Matrix report.

         

        Thanks

        Amit