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
Hi Dataseeker009 ,
Thanks for the reply from Kedar_Pande and quantumudit , please allow me to provide another insight:
The OR function in DAX takes only two arguments, so you can use the OR operator (||) to join all calculations into a simpler expression.
Flag =
VAR _selectedRole = SELECTEDVALUE(RoleDimension[Role])
RETURN
IF (
MAX('Table'[Role]) = _selectedRole ||
MAX('Table'[Role]) = "All" ||
MAX('Table'[Role]) = "All Other",
1,
0
)
It is worth noting that do not create a relationship between the two tables.
The final result is shown below, more details can be found in the attachment.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.