Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |