I need some help and hopefully someone can guide me. I was following the Dynamic Dashboards YouTube video and found this to be helpful in my project. I have change the filter to pull in Site codes, but it pulls in all site codes found including the duplicates. Below is my Row Filter that I am using on my slice data to pull back the site codes. Is there a way to change this so that I have unique values only? I have also included some screenshots of my Dashboard and the filter options that show up. Any help will be appreciated.
Row Filter: IF(ISBLANK(ANY(Dashboard Filter[Site Filter])), TRUE,[SYSTEM NAME] = ANY(Dashboard Filter[Site Filter]))
Dashboard:
Site Filter current options:
Solved! Go to Solution.
Share here your expression for Valid_If (or Suggested values maybe?) on your Site Filter dropdown and we can help.
I suspect that if you just wrap everything from there on a UNIQUE() function, it should be enough
Share here your expression for Valid_If (or Suggested values maybe?) on your Site Filter dropdown and we can help.
I suspect that if you just wrap everything from there on a UNIQUE() function, it should be enough
Thank you SkrOYC. A UNIQUE() function did helped.
Valid_If:UNIQUE(LIST(BFD,BIL,BUF,CHI,CMD,GHO,LAN,LOU,ONT,PLY,POR,QRO,SLC,TAM,TEC,TIJ,TOR,VAL))
But now how do I adjust my row filter to pull in all results of the code in each chart? This is still only pulling back one result.
Mmm, your expression is weird. It already has unique values.
Are you sure you just have that expression? I mean, can you share your whole column config?
I expected something like:
UNIQUE(
TableToBeFiltered[SYSTEM NAME]
)
SkrOYc,
thank you very much. I figured out that I had the wrong column referenced in my row filter. Once I adjusted, it is now working. Thank you for your help on the first part.
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |