Forum Discussion

TXT0VBI's avatar
TXT0VBI
Frequent Visitor
4 years ago

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. Thanks alot in advance.

 

If I select Project D in the Filter selection the table should be updated like above. and the difference values should change if I selct Project C in the filter dynamically. Thanks again!

2 Replies

  • MahyarTF's avatar
    MahyarTF
    Icon for Memorable Member rankMemorable Member
    4 years ago

    Hi,

    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

    • TXT0VBI's avatar
      TXT0VBI
      Frequent Visitor
      4 years ago

      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