Forum Discussion
Delta between the Columns based on the slicer selection in matrix
I have a requirement in Power BI where I have to find the delta between the cost items of the project based on the project selection in the Filter dropdown. Can you please help me with the dax for it...
MahyarTF
Memorable Member
Memorable MemberHi,
Not sure if it is possible, But you could use the parameter in power bi, if it is okay :
- Create the Field parameter in Power BI :
2- Put all the columns in the parameter :
3- then the slicer will created automatically in your page and also you need to develop the table visual included the CostItem and Parameter column :
the selected item in Slicer will shown in the table visual
Appreciate your Kudos
Thank you so much but the difference should be dynamically calculated based on the filter selection for suppose If I selected project D in the filetr selection then the difference columns adjacent to the projects should give delta between the corresponding project and project D