Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.