Showing results for 
Search instead for 
Did you mean: 
dmistry Regular Visitor
Regular Visitor

How to setup a custom table based dashboard to represent the data from created measures in below



Hi, I am about to start working on a PowerBI project for a client and wanted to get some good ideas on how effectively I can design the visual dashboard in the below scenario:




You can see in the above screenshot that the layout is a table based. All the categories highlighted in red are categories for which there is a account number available in Database. So for example, I will be creating 7 measures for category like 'Digital Ads', one for FY18 Estimations at 9/30, Second for FY18 budget, third for FY18 budget vs FY18PROJ using the account number and so on. 


What I am trying to figure out is what would be the best way to place these created measures, exactly as shown in the screenshots above, can someone please share ideas. I woud like to make sure that the dashboard i design should  match 100% to the one shown in the screenshot. It becomes easier in case if the data is coming straight from a DB table but I am not sure, how can I do it in case of when you have values coming from the created measures. 


FYI, I will be integrating a date table which will have a relationship defined to the table data coming from Database. Also the measures I create, will have conditions like calculate for this account number where FiscalYear is 2018. In SSRS reports, we can exactly match this but since this is PowerBI I want to see how this can be done better. Also no amounts are coming straight from Database, they will be displayed via a calculated measure.


If you have ideas, please share and help, I would appreciate it, thanks in advance. 

Community Support Team
Community Support Team

Re: How to setup a custom table based dashboard to represent the data from created measures in below

Hi @dmistry,

Could you please offer some sample data to have a test?



Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.