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 have data in three different columns and I want to create a slicer with this data.
Please suggest a way to do the same.
Solved! Go to Solution.
Hi @Pri ,
Go to power query as the picture as below.
Then choose all the columns and upivot columns as the picture below.
Provide sample data and expected output.
Sample Data :
Total Value | Internal Value | External Value |
100 | 40 | 60 |
70 | 30 | 40 |
Expected Output:
Slicer with three options in dropdown : Total Value, Internal Value, External Value
Based on your provided data, try this:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQwUNJRMgERZgZKsTrRSuYgtjFUNDYWAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Total Value" = _t, #"Internal Value" = _t, #"External Value" = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Total Value", Int64.Type}, {"Internal Value", Int64.Type}, {"External Value", Int64.Type}}), #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {}, "Attribute", "Value") in #"Unpivoted Columns"
Where do I need to paste this code?
Hi @Pri ,
Go to power query as the picture as below.
Then choose all the columns and upivot columns as the picture below.
In power Query, Advance Editor.
Delete everything from there and paste the code.
This is based on the data you provided.
Follow the applied steps on your own data to achieve what you needed.
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |