Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi everyone,
I have only just started using Power BI as a new client uses it currently, thereby I have been asked to start using it as a way of summarising data for auditing purposes.
I have a bit of experience with Access however Power BI seems to be a bit of a different ball game.
The thing I am trying to do is create a matrix which contains multiple values for each given row.
An example which I pulled together on excel is below.
At the moment, I can get something that remotely resembles this. but it only comes up with the first or last instance of the document title.
I am also going to peform conditional formatting on a "complete"
Hopefully this is just an option that I am missing.
Thanks in advance
Liam
Hi Liam,
Can you share a sample of the original data? It seems you'd like to show all the details. I'm afraid that isn't a function of a Matrix visual. I would suggest you try other custom visuals like "rDataTable".
Best Regards,
Dale
User | Count |
---|---|
59 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
78 | |
62 | |
45 | |
40 | |
39 |