Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

Hello,

 

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:

 

Capture.PNG

 

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. 

1 REPLY 1
v-danhe-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous,

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

 

Regards,

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.