How can I condense multiple rows into a single cell in a Matrix or a Table? https://youtu.be/bjCclP7aTCQ Obviously, it is easy to display all details like you see below: But what if for every product I just want to know what countries it is selling in and what channels are used? Like how it is … Continue reading How to Display Multiple Rows in a Single Cell of a Matrix or a Table
Month: October 2021
Inforiver – The Best Custom Visual in Power BI?
This might be the first (and possibly only) time in a very long while that I got really excited about a custom visual for Power BI. Yes, I use custom visuals every now and then, but generally speaking I would have to admit that I am not a fan. Most of them do a good … Continue reading Inforiver – The Best Custom Visual in Power BI?
How to Hack RLS to Make RANK() Work on Entire Dataset
Let's say you are building a dashboard for the Sales team and have the following requirements: Each sales person should have access to only their territory - Ok this is easy enough. We can achieve this using RLS. Rank the territories based on revenue. Sales person should be able to view the ranking of their … Continue reading How to Hack RLS to Make RANK() Work on Entire Dataset