Forum Discussion
Make column headers in a Power BI Matrix visual dynamic based on slicers
Hello everyone,
I've set up a Matrix visual displaying sales data based on geographical locations: Europe, Asia, and Africa. The Matrix includes three measures: Sales 1, Sales 2, and Delta.
Sales 1 corresponds to selections made in the Loc1 slicer, Sales 2 to the Loc2 slicer, and Delta represents the difference between Sales 1 and Sales 2.
I'm looking to make the Matrix columns dynamically adjust based on the selections made in the Loc1 and Loc2 slicers.
Thanks
4 Replies
ChiragGarg2512Solution Sage
Anonymous Field parameter can help in this matter. Two field parameters, one for the locations and other for measures. Apply these parameters to slicers[independent] and to matrix visuals(rows or columns) as per need.
Unfrtunality , its not working , values are not changine :
Parameter = {(FORMAT(SELECTEDVALUE(Sales_Loc1[Loc1], "No selection"), "mmmm"), NAMEOF('Sales_Loc1'[_Sales_loc1]), 0),(SELECTEDVALUE(Sales_Loc2[Loc2], "No selection"), NAMEOF('Sales_Loc2'[_Sales_loc2]), 1),("[" & [_Loc2_selected_value] & " - " & [_Loc1_selected_value] & "]", NAMEOF('Sales_Loc2'[_delta]), 2)}Where if I replace the first column in Parmater with dates fucntions , they will work:
https://www.youtube.com/watch?v=9_2m5Csr55c&t=186s
Any Sugesstions 🙂
- ChiragGarg2512
Anonymous There is no way to get a slicer that affects one column but not the other. What can be done is get both the locations and both the measures giving 4 columns[Loc1 Sales1, Loc1 Sales2, Loc2 Sales1, Loc2 Sales2] and use them as per need.