Forum Discussion
TopN with others - WITHOUT additional table? (SSAS Tabular)
You are right, the standard matrix visual would not work for this as there are no rows to tag the measure against. I am wondering if there are other matrix type visuals that can do that.
I also didn't catch the fact that you are doing this on RS - that may further complicate things as custom visuals are more tricky there.
See attached for a visual, erm, "solution" .
hi,
I've prepared a sanitized dataset for you with just the case.
please follow this link
ZIP: https://drive.google.com/file/d/1awfmZQLftIELkMLqOg3h9f-WJj6cmlfu/view?usp=sharing
PBIX : https://drive.google.com/file/d/1tx9YfsNV7mgVACR9Hry51E5vh4d9BPNB/view?usp=sharing
I've included the desired result example as a picture, in the file as well.
Thanks again.
You are right, the standard matrix visual would not work for this as there are no rows to tag the measure against. I am wondering if there are other matrix type visuals that can do that.
I also didn't catch the fact that you are doing this on RS - that may further complicate things as custom visuals are more tricky there.
See attached for a visual, erm, "solution" .
Thank you for your efforts though.
I've added my thumbs up to the feature request at Microsoft Idea · Add others options to TopN Filter (powerbi.com)