Creating an interactive dashboard.

(0) Share

Report

Posted on by JB-02012010-0

Greetings, I am trying to take the data that I will be inputting throughout the year and turn it into an interactive dashboard that will make it easier to read. I have inserted a screenshot below of what the data tab looks like, and it pulls its data from the month tabs. I am looking to see if it is possible to create a dashboard using the data screen I have or do I need to change it.

I would like the dashboard to have the following options: 1.) Show the totals overall in a chart. 2.) Have the option to show the totals by month if I click on the month. 3.) Have the option to click on each equipment number and show the overall data for that specific piece equipment as well as each month.

This will be first time I have attempted to create a dashboard and everything I see on online does not help with the data tab I am using. Any help will be appreciated. I can provide more screenshots if requested.

Categories:

Microsoft Dataverse with Power Apps

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Appser.IT 23 on at

Like (0)

Report
Copy link

Link copied!

It is duable. Maybe prepare screen to see how it should look like in PA. You could use figma . It is great tool to create mockups. Second thing is datamodel. For this fine is https://dbdiagram.io/ .

Need help?

Was this reply helpful? Yes No
Suggested answer

SwatiSTW 807 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@JB-02012010-0

Yes, you can create a dashboard based on your "Data" tab—no need to restructure everything.
Here’s a straightforward way to do it in Excel:

Normalize your data using Power Query:

Select the monthly columns (Green Sheet, In Use W/o Form, Hours Filled across Jan–Dec)

Unpivot them to get a table with columns like: Unit ID | Equip No | Month | Metric | Value

Create a Pivot Table from that normalized data:

Rows: Unit ID or Equipment No.

Columns: Month or Metric

Values: Sum of Values

Add Slicers for Month and Equipment No to make it interactive.

Insert Pivot Charts based on what you want to display (totals, by month, by equipment).

Arrange everything nicely on a separate “Dashboard” sheet.

This will let you:

See overall totals

Click on a month to filter

Click on equipment to drill down

Let me know if you want help with the Power Query steps.

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,714 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @JB-02012010-0

I feel its good to use Power BI report for the same. Lets wait for others comments as well

Please mark as answer if my suggestion helps.
Subscribe here for More Useful videos : https://www.youtube.com/@rampprakash3991

Was this reply helpful? Yes No