Forum Discussion
How to show default Rows in Matrix Visual Chart even though Slicer is applied on page.
Hello Dataseeker009
To simplify the process, you can take the following steps:
Create a dimension table as shown:
Next, establish a relationship with these properties:
This should yield the desired outcome, as illustrated here:
This method is a quick fix, but it may lead to complications with more complex data models in the future. A more effective solution would require a deeper understanding of your data model's structure and intricacies.
For straightforward data models, this approach should suffice and can be implemented.
Best Regards,
Udit
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍
🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree
Flag measure:
Flag =
VAR _selectedRole = SELECTEDVALUE(RoleDimension[Role])
RETURN
IF (
OR (
MAX(Table[Role]) = _selectedRole,
MAX(Table[Role]) = "All",
MAX(Table[Role]) = "All Other"
),
1,
0
)
Add a visual level filter using the Flag measure:
Set the filter condition to show only rows where Flag equals 1.
Make sure your slicer is based on the RoleDimension[Role] field, so when users select "QA", the Flag measure will determine which tasks to display.