Forum Discussion
Advocate INew table /Power Query based on Dynamic Filters from the slicers
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
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.
2 Replies
v-caliao-msftMicrosoft Employee
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
ANKITBISANIHello 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.