Summarize Table Header

[JPlancke]

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:

Thanks a lot in advance guys!

[dilumd · Accepted solution]

Hi

If you are looking for somthing like this,

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

[JPlancke]

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