Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@Anonymous
you can use a table for this with filtered columns.
Add a column in the table and create filtered measure as per the category.
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
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |