Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

PowerBI Reports and Drilling Down for Correct Works

Good Day Support, 

I am new to PowerBI, but i would like some guidance is building a report from the attached spreadsheet

Header at top of page  

Chart showing No of Each priorty Jobs and their status drill down who it is assigned too
Chart showing No. of issues raised by each person, the lead person in charge and the status of the job
Chart showing No. of Notification created, Notification Type, notification status
Chart showing no. of issues raised each month drilling down by type and the no. of days it took to complete task
Chart showing the of issues assigned to different sections


Thanks much for your assistance.


Community Support
Community Support

Hi @KPro17 


The requirement is not detailed. There are many types of visualizations in Power BI (Visualization types in Power BI). You could explore some of them to decide which one you hope to use for each chart in your report. You could add fields to visuals to check the result. As you want No. of some fields, you could aggregate a column with Count or Count (Distinct) type in a visual. Right click on a column in Values card of a visual and select a proper aggregation type for it. 


You could start with Table visualizations. Table is the most basic visual and it can show results directly. 


Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Super User
Super User

@KPro17 , Attachment is missing. Please ask for specific challenges. What are the formulas for these?

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors