Power BI

[amsrivastavaa]

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 

[v-stephen-msft]

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]

HI @v-stephen-msft ,

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