Matrix like visual - Advise on visuals

[Anonymous]

Hey ALL,

I have a table with 3 (will be more) calculated columns.

Each column gives me values of -1,0,1 according to some dates logic. I use these values to filter a measure that is shown on cards, as described below.

In the visual below, each number (pointed at with pink arrow) is a card, which shows the same measure. Columns and values are text boxes.

Any better way to show this kind of data?

Thanks!
A

[adityavighne]

@Anonymous 

you can use a table for this with filtered columns.

[Anonymous]

Hi @adityavighne 

Can you elaborate?
Not sure how to achieve this.

Cheers!
A

[adityavighne]

Add a column in the table and create filtered measure as per the category.

[Anonymous]

Hey,

Thanx for the advise. I dont see how it helps me, though.

1. I did not want to creatre more/other measures.

2. The result will come in a row, while I want it in a column.

Unless I am missing something?!

I would like to create a table with 1 measure and in each row/column (aka cell) I will use different filters.

For example:

Column 1

51 --> Measure X1 with filter with columnA (value 1) applied.

434 --> Measure X1 with filter with columnA (value 2) applied.

742 --> Measure X1 with filter with columnA (value 3) applied.

Column 2

129 --> Measure X1 with filter with columnB (value 1) applied.

259 --> Measure X1 with filter with columnB (value 2) applied.

etc. etc.

Cheers!
A