Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Accountid Metal Segment 2 Segment 3
Account 1 TRUE FALSE FALSE
Account2 FALSE TRUE TRUE
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?
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
Sorry for not being clear.
I would like to be able to show these six yes/no values in one visual.
The slicer comes from a related table.
try "Sunburst" visual from market
Because the data is not hierachical it does not really show how many accounts are in each segment.
HI @Mezmarianne,
Try the KPItable custom visual you can have a table with (traffic light images) to display values.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Mezmarianne,
Have you resolved your issue, please marlk the right reply as answer. So more people will benefit this.
Best Regards,
Angelia
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.
Hi @Mezmarianne,
Did you use the matrix visual? If it is, you can use the conditional formatting?
Best Regards,
Angelia
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |