Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have data in the above format and I wish to show it like this for any particular day:
Is it possible?
Thanks!
Solved! Go to Solution.
There's not really a need to do that in DAX. All the necessary transforms are done in Power Query. Or am I missing something?
There's not really a need to do that in DAX. All the necessary transforms are done in Power Query. Or am I missing something?
Ok Thanks! I'll try it 🙂
Here is a simplistic approach using some Power Query but mostly the matrix visual. Let me know if you need it all in Power Query.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("JY3BCsIwDIbfpefB1j6CO8yDguhA2Ogh1mwNurbE7v1N9JL/40/4Ms/GtrZ1nbOmMSfKSWIghmVBoT4iVohCV3zKPLx3rQdG1MMemHMVGPMGNQtcsBTkj/GNip2KOzUfqRTdj7QiS074YJA8w4qpKt0jVfy9gPBSU65/5bSHECmR4K1QghCN918=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t, #"Animal 1" = _t, #"Animal 2" = _t, #"Animal 3" = _t, #"Colour 1" = _t, #"Colour 2" = _t, #"Colour 3" = _t, #"Veg 1" = _t, #"Veg 2" = _t, #"Veg 3" = _t]),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Date"}, "Attribute", "Value"),
#"Split Column by Delimiter" = Table.SplitColumn(#"Unpivoted Other Columns", "Attribute", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, false), {"Attribute.1", "Attribute.2"})
in
#"Split Column by Delimiter"
Great! That seems to work in the answer, but I still need to understand how to put that in Power BI (DAX?)
you can include text tables in your post. No need for Excel.
I tried many times and it gives me an "HTML detected" error. When clicking on "remove HTML and try again" it goes into a loop. Which is why I had to paste it as a picture to begin with.
yes, this is certainly possible in Power Query or in DAX (setting aside the question of why?!? )
Please provide sample data in usable format (not as a picture) and show the expected outcome.
I can't seem to upload an excel here - it isn't too difficult to re-create though.
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 |
---|---|
7 | |
2 | |
1 | |
1 | |
1 |