Forum Discussion
simon_pbi_data
2 years agoFrequent Visitor
Dynamic Column based on Slicer selection value Power BI
Hi everyone, I need to create a dynamic column based slicer on my report. Let me explain better: I have this table in my datamodel: level_4 level_5 level_6 level_7 italy south apulia...
IanCockcroft
2 years agoPost Patron
hi Simon,
Have you tried using field parameters?
I am putting a pbi togeher to see if that works.
mean time, check this out
https://www.youtube.com/watch?v=elnY9LtuhMU&t=107s
chees
Ian
simon_pbi_data
2 years agoFrequent Visitor
I don't know, because I need to have slicers at the top like in the example.
I thought of a type of calculated column that dynamically changes its values based on the selection made in the slicers at the top of the report.
Your solution comes very close but I wouldn't be able to insert the condition where "if you filter something by level_4, you must return only the values of level_5"