Transforming the matrix visualization to look more like a table

[Zyg_D]

This is the data: 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUSqpLEg1BNKJJSVFmUmlJWCOkYGhhVKsDn4VloRUGBmAVTgRNAOPCqgZzlAVRjjNwKMCaoYLNhVGcBWxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t, Type = _t, Attribute = _t, Years = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Type", type text}, {"Attribute", type text}, {"Years", Int64.Type}})
in
    #"Changed Type"

 

My current Matrix visualization looks like this: 

How can I remove the grouping (it results in 2 almost empty (thus useless) rows)? The desired result should look like this: 

[AllisonKennedy · Accepted solution]

You can turn the stepped layout off. https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

[amitchandak · Accepted solution]

@Zyg_D ,  The nearest you can have is stepped layout off.  But that will show value once for repeating values

refer: https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

[Pragati11]

Hi @Zyg_D ,

You can try creating a measure:

nameCount = IF(COUNT([Name]) = BLANK(), 0, COUNT([Name]))

Move this measure to the VALUES section of your matrix chart.

Thanks,

Pragati

[Zyg_D]

---

@Pragati11 wrote:

Hi @Zyg_D ,

You can try creating a measure:

nameCount = IF(COUNT([Name]) = BLANK(), 0, COUNT([Name]))

Move this measure to the VALUES section of your matrix chart.

---

Hi, Pragati. I tried your suggestion. Sorry to say, but replacing Count of Name with this measure does not change a single thing in the report. 

[AllisonKennedy · Accepted solution]

You can turn the stepped layout off. https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual