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.
Hi,
I am trying to create a Donut Chart. My Requirement are as below.
I have one table. Where we have stored.
1. Monthly Volumes, Based on Some Category as each row.
Now I want create two charts.
1. Table Chart - For Category,Monthly Volume, Percent Impact -> It is done and working fine.
2. Second is donut chart. - as below. with mentioned requirement
The above donut chart I have creating. using table in different format.
This is urgent requirement.
Thanks in advance.
Hi @Anonymous
Please use the M code to transform your table as below:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("XZA7DgIxDESvskq9hR1/4tQcA21BgSiREA23Z2doUJo4cd5Mxrle2+X2vj+er8+2adubichZYta5dpeOUmiZVjv2fx53+uO1Q1xjnutMaGKBDRTciatQoFqTGh9Bs/BcdI6nI6mKgYMLvToTzgWHTUjBMx1B3B24gU5ZRwChVbQiohl4arChC81ucjwGws447FhIGpbSBZEYhX9p1o7jCw==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Reporting category" = _t, #"Current month volumes" = _t, #"Total not currently reported" = _t, #"Successful reporting" = _t, #"Inaccurately reporting" = _t, #"Incomplete reporting" = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Reporting category", type text}, {"Current month volumes", Int64.Type}, {"Total not currently reported", Int64.Type}, {"Successful reporting", Int64.Type}, {"Inaccurately reporting", Int64.Type}, {"Incomplete reporting", Int64.Type}}), #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Reporting category", "Total not currently reported", "Current month volumes"}, "Attribute", "Value") in #"Unpivoted Other
And then create the donut chart: (keep the drill mode on)
When you click category 3 in the first donut chart, or select inaccurate in the second chart:
Attached pbix here for your reference: https://wicren-my.sharepoint.com/:u:/g/personal/dinaye_wicren_onmicrosoft_com/EcQHotD-Gd9BhpW4-PuXU-0B2WcTmCkUg-qa6WGavaJ-Ag?e=dD8Dva
Best regards,
Dina Ye
Hi @Anonymous
If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!
Best regards,
Dina Ye
Covering 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 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |