Forum Discussion
Dynamic hierarchy based on user login in a matrix visual
Hi Charan77
Do this:
Create a table with a column containing the distinct values of both L1 and L5 using either DAX or M.
Create relationships between that table and the original Dim table - an active relationshipo to L1 and an inactive to L5 or the other way around.
Use the column from this table in matrix as L1 and the other columns from the original table.
Create a measure that checks whether the user is in the list to be restricted and whether the column in the second-level hierarchy is currently inscope. Invoike the inactive relationship with USERELATIONSHIP if the above conditions are true else return a the base measure/aggregation.
Note: the boldness of the category font cannot be controlled with DAX (currently).
Please see the attached pbix.
Super UserHi Charan77
Do this:
Create a table with a column containing the distinct values of both L1 and L5 using either DAX or M.
Create relationships between that table and the original Dim table - an active relationshipo to L1 and an inactive to L5 or the other way around.
Use the column from this table in matrix as L1 and the other columns from the original table.
Create a measure that checks whether the user is in the list to be restricted and whether the column in the second-level hierarchy is currently inscope. Invoike the inactive relationship with USERELATIONSHIP if the above conditions are true else return a the base measure/aggregation.
Note: the boldness of the category font cannot be controlled with DAX (currently).
Please see the attached pbix.
Hi Charan77,
I would also take a moment to thank lbendlin , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Regards,
Harshitha.Hi Charan77,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.
Regards,
Harshitha.Hi Charan77,
I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.
Regards,
Harshitha.