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.
On my dashboard I have several measures in a Card mode but I want this measure to appear like they are un a Table visualization.
When I try this I have all my values on the same line. I want them presented with one measure per row.
I got it like that
But I want the representation more like this :
Solved! Go to Solution.
Hi @Anonymous ,
You can create a new table with all type of measure, then write a measure with switch function to check current type and return correspond measure result.
Table = DATATABLE ( "Type", STRING, { { "A" }, { "B" }, { "C" }, { "D" }, { "E" } } ) Measure = SWITCH ( SELECTEDVALUE ( 'Table'[Type] ), "A", "Measure1", "B", "Measure2", "C", "Measure3", "D", "Measure4", "E", "Measure5", "None" )
Regards,
Xiaoxin Sheng
Hi @Anonymous ,
You can create a new table with all type of measure, then write a measure with switch function to check current type and return correspond measure result.
Table = DATATABLE ( "Type", STRING, { { "A" }, { "B" }, { "C" }, { "D" }, { "E" } } ) Measure = SWITCH ( SELECTEDVALUE ( 'Table'[Type] ), "A", "Measure1", "B", "Measure2", "C", "Measure3", "D", "Measure4", "E", "Measure5", "None" )
Regards,
Xiaoxin Sheng
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |