cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Summarize Table Header

Hi all,

 

I am fairly new to Power BI and currently struggling to create a visualization.

 

The data I am visualizing is about insurances and Risks associated to these insurances. For this we have a Summary table where each unique insurance represents a row. The first column is the unique identifier (insurance number) and the following columns are the risk columns. For each insurance, the risk is flagged via a 1 or 0 (1 = flag set, 0 = no flag) in each risk column. 

 

I am looking to visualize via:

 

A bar chart where each value on the X-axis is a risk and the bar itself should represent the number of insurances that have this specific risk. 

 

But there is a catch to it: If I select a specific insurance (e.g. from a table) I want this bar chart to visualize the specific risks that were flagged for that insurance. So, this has to be visualized based on my Summary Table (not via an intermediary table where the totals for each risk are calculated, since this does not allow me to filter down any further based on an individual (or group of) insurance(s) ).

Refer to the image below for a basic example done in Excel:

Capture 3.PNG

 

Thanks a lot in advance guys!

1 ACCEPTED SOLUTION
Solution Supplier
Solution Supplier

Hi

 

If you are looking for somthing like this,

Insurance.JPG

 

you can use unpivot columns in power query and then use that as a source for this chart.

 

Unpivot.JPG

View solution in original post

2 REPLIES 2
Solution Supplier
Solution Supplier

Hi

 

If you are looking for somthing like this,

Insurance.JPG

 

you can use unpivot columns in power query and then use that as a source for this chart.

 

Unpivot.JPG

View solution in original post

Thanks a lot dilumd!

 

The problem is indeed solved by pivotting the table and building the visualization based on the new source. 

 

Yours best,

 

JP

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

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

Top Solution Authors
Top Kudoed Authors