Caporegime
Hi all
I need to create a custom PowerBI dashboard that replicates something I've already created (and had signed off by top brass) in Excel.
I've told them I can save developer money and do it myself, which I'm starting to regret as everything seems a lot harder to sort and layout vs. Excel.
The main issue I have is that each cell of the dashboard is a specific value or metric from any given table of which there are dozens.
For example the first cell might be in month sales then the cell below might be 12-month contract pipeline.
Are there any good resources that I can use to figure out how to do this? Would I be best setting out multiple individual tables or a single matrix with DAX, custom measures, and combined queries?
Many thanks.
I need to create a custom PowerBI dashboard that replicates something I've already created (and had signed off by top brass) in Excel.
I've told them I can save developer money and do it myself, which I'm starting to regret as everything seems a lot harder to sort and layout vs. Excel.
The main issue I have is that each cell of the dashboard is a specific value or metric from any given table of which there are dozens.
For example the first cell might be in month sales then the cell below might be 12-month contract pipeline.
Are there any good resources that I can use to figure out how to do this? Would I be best setting out multiple individual tables or a single matrix with DAX, custom measures, and combined queries?
Many thanks.