Forum Discussion

amsrivastavaa's avatar
amsrivastavaa
Helper III
3 years ago

Power BI

Hi Guys!!

 

I have this layout of the report 

 

Filters : YEAR and Range.

 

Range Filter works on Measure named Measure_Selector, i.e. when any value in RANGE filter is selected, every record in the table will get Matrix_Selector as 1 or 0, and whereever Matrix_Selector =1, data is of our interest

 

In above case, when user selectes Range=<25%, then record where Project=ZEE5 is qualified as Matrix_Selector is 1 for records.

 

Till here I am good, I am able to acheive the same.

 

FYI, Base Table looks like as below, i.e. having multiple KPI and multiple Year data for one Project.

 

 

Requirment : 

My ultimate requirement is to display data into the another MATRIX Visual for only those Project and YEAR where we are getting Matrix_Selector=1 above, i.e. Project=Zee5 and Year=2020  but for all the KPI's, so my Matrix will show data as below, i.e, need to show all the KPI for Year=2020 and Project=ZEE5

 

 

Please suggest, How to do it.

 

Thanks

Amit 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi amsrivastavaa ,

     

    Have you tried to put the measure named Measure_Selector into the visual-level filters of the matrix?

    When you put it, set up show items when the value is 1. The result of the matrix will be filtered.

    Add a filter to a report in Power BI - Power BI | Microsoft Learn

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • amsrivastavaa's avatar
      amsrivastavaa
      Helper III
      3 years ago

      HI Anonymous ,

       

      We can do that but it will not help me to acheive my requirement.

       

      I need to display data for all the measure for the projects those identified in very first step.

       

      I.e. Very first, I need to figure out what are Project and YEAR identied when User selects RANGE=<25% for KPI=Subscription Revenue; then need to display all the measure against those Project and Year.

       

      If, i will place matrix_slector as a filter in Matrix visual, it will only shown records for one KPI only i.e. Subscription Revenue.

       

      Thanks

      Amit Srivastava