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

Visualizing multiple true/false questions in ONE visual

I would like to find a good visual for displaying segmentation of accounts (and leads).

 

Each account has about 6 segmentation columns which can be TRUE or FALSE. Leads have the same segmentation columns.

 

I have an extra table with the TRUE/FALSE value and a translated value.

So the visual could be like the sunburst visual - but my values are not hierachical.

So a count of accounts in first segment. - And a count of accounts in second segment. And all accounts can be in 0-6 segments.

 

I need to display the value from the extra tabel with only two columns and two rows, because this extra table works a a dataslicer for both accounts and leads.

Capture.PNGData Model Snippet

 

Accountid   Metal      Segment 2      Segment 3

Account 1   TRUE       FALSE              FALSE

Account2    FALSE      TRUE               TRUE

10 REPLIES 10
Highlighted
Super User
Super User

Re: Visualizing multiple true/false questions in ONE visual

Hi @Mezmarianne,

 

Check this answer I gave in a previous post with similar option.

 

https://community.powerbi.com/t5/Desktop/Help-with-display-chart/m-p/177592#M77680

 

Please tell me if it work or if you need any help.

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




v-huizhn-msft Super Contributor
Super Contributor

Re: Visualizing multiple true/false questions in ONE visual

Hi @Mezmarianne,

I still have several problems to confirm.

1. What you resource table look like, from the data snippet, I didn't see "Each account has about 6 segmentation columns".

2. You want to display your data in sunburst visual? But sunburst visual needs different categories in different levels, your data does not match the format.

3. The following part is your expected result table?

1.PNG

4. >>I need to display the value from the extra tabel with only two columns and two rows

What's the mean of the setence? 

Could you please share more details and sample table, list the expected result, so that we can post solution which is close to what you want.

Best Regards,
Angelia

Mezmarianne Regular Visitor
Regular Visitor

Re: Visualizing multiple true/false questions in ONE visual

Sorry for not being clear.

segments.PNG6 segmentsMetalYES.PNGData slicer for Metal set to Yes

Mezmarianne Regular Visitor
Regular Visitor

Re: Visualizing multiple true/false questions in ONE visual

I would like to be able to show these six yes/no values in one visual. 

The slicer comes from a related table.

Iadem Frequent Visitor
Frequent Visitor

Re: Visualizing multiple true/false questions in ONE visual

try "Sunburst" visual from market

Mezmarianne Regular Visitor
Regular Visitor

Re: Visualizing multiple true/false questions in ONE visual

Because the data is not hierachical it does not really show how many accounts are in each segment.

 

Sunburst segmentering.PNG

Super User
Super User

Re: Visualizing multiple true/false questions in ONE visual

HI @Mezmarianne,

 

Try the KPItable custom visual you can have a table with (traffic light images) to display values.

 

KPITable

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




v-huizhn-msft Super Contributor
Super Contributor

Re: Visualizing multiple true/false questions in ONE visual

Hi @Mezmarianne,

Have you resolved your issue, please marlk the right reply as answer. So more people will benefit this.

Best Regards,
Angelia

Mezmarianne Regular Visitor
Regular Visitor

Re: Visualizing multiple true/false questions in ONE visual

I am not quite there yet. Now I have settled for 6 tables (preview version). If clicked, the maps only shows the selected type. More than one can be selested. But there is no color indication that a row has been clicked, when there is only one row.

segments in tables.PNGSegments in tables

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 44 members 890 guests
Please welcome our newest community members: