Change column value type and calculation automatically in matrix table based on clicking on slicer

[NISHA_S]

i have report contain differnt category wise data want to show... i used a slicer to show different category and used matrix table to show calculated values...i tried to attach pbx files for refrence ...but i can't...This is my report..

I used one table fact...that is 

then for getting values in slicer i used a temp table which is shown below...

First thing is,there is no relation between temp table and fact table...My requirement is while i click on each category ,based on that matrix table calculation i want to change..ie...if click on construction type ,based on that category values want to show and Matrix table 2nd column wants to change based on click slicer type....The thing is each category is in different column...Is there any solution is there to show like this...(Like group by changing in query )

[NISHA_S · Accepted solution]

https://stackoverflow.com/questions/52839914/powerbi-show-hide-column-based-on-slicer-value

[amitchandak]

@NISHA_S , not very clear, but seem very similar to the change of axis.

Refer if these can help

Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/

[NISHA_S]

here am sharing pbx file for refernce

https://www.dropbox.com/s/63jiu6j8bqx4ynj/sampletest.pbix?dl=0