New table /Power Query based on Dynamic Filters from the slicers

[ANKITBISANI]

Hello Experts ,

Lets suppose , i have a fact table  A which consist of 1000 rows and having column as Zone , City , Age group and Sales amount  as fact.

Now I have a dimention table B which consist of various attributes like Zone , City , Age group etc)

I want to reduce/Filter  the fact table based on Zone , City , Age group randomly from the slicers which I have.

Eg: Sometimes East zone is selected so that should only bring rows with east zone .....Then sometimes there is chnage in filter like city so accordingly it should filter.

1. is there any possibility to change the number of rows dynamically with changing filters with the help of Power/table query??

(there has been a 1: m relationship maintained between dimention and fact)

2. If ,Yes , can I have a custom column on the new table which would get created out of query.

Let us know , if more information required

Regards ,

Ankit

[v-caliao-msft]

Hi @ANKITBISANI,

Why do you need to achieve this in Power query? Power BI provide a slicer visual to acheve this requirement in report level easily. And in your scenario, there are only 1000 rows in your fact table. Obviously, there won't be a performance issue.

Please refer to the link below to see the details about Slicer in Power BI.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-slicers/

Regards,

Charlie Liao

[ANKITBISANI · Accepted solution]

Hello @v-caliao-msft ,

I have handled it on the measure level and then put it into my reports .

In measure I have used ALLSELECTED function.

So the required dynamism was implemnted in the visual.