Forum Discussion

amsrivastavaa's avatar
amsrivastavaa
Icon for Helper III rankHelper III
3 years ago

Data Range in Power BI

Hi Guys!!   I landed into very weird kind of requirement, the same has been detailed below.   Source Data :    Project Type Year Channel Amount P-1 Credit 2017 1 20 P-2 Credit...
Need Help
amsrivastavaa's avatar
amsrivastavaa
Icon for Helper III rankHelper III
3 years ago

Hi amitchandak ,

 

I gone through the video and its seems good however I have a bit different requirement than that

 

1. In my case, there is filter channel=1 which filters data and then I need to apply another logic.

2. After filteration, what ever Project left, I need to have data for all project with TYpe and Year and then matrix will form on top of that data.

 

Thanks

Amit

amsrivastavaa's avatar
amsrivastavaa
Icon for Helper III rankHelper III
3 years ago

Hi amitchandak ,

 

I am able to achieve first part of query.

 

Could you please help me find solutions for second part as well.

 

I.e. once I have data with Table visual where Filter based on Measure is used, then how would I load data into another visual with only Project and Year where I have Measure Filter value =1.

 

Please suggest 

 

Thanks

Amit