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.
Hello,
I have a set of measures which vary depending on the date choosen by the user via a slicer. The slicer has a start and end date which analysis is made over.
I have three variables (A, B & C) with three measures for each (Ax3, Bx3 Cx3). For example, for variable A I calculate its start value, change in value and End value. The same calculations are made for B and C. Analysis shows the results of each measure at the start, end and the change between the time period selected in the slicer.
Start A | Change A | End A |
Start B | Change B | End B |
Start C | Change C | End C |
To join these measures and there results together in a nice presentable table I created a new table via the following command:
-- | Start (USD) | Change (USD) | End (USD) |
A | 50 | -10 | 40 |
B | 5 | 0 | 5 |
C | 20 | 10 | 30 |
BUT there's a problem...The slicer has no effect on the table due to it being in a different table with no relationship. Can I use some kind of DAX code in my union, row code instead of calling Start A, B, C, Change A,B,C, End A,B,C value?
Any suggestions would be greatly appreciated 🙂
Solved! Go to Solution.
I ended up creating three matrices in the orignal field. You can set the value to be "banded row style" for matrix data, giving:
(Column header added below)
A | 10 |
B | 3 |
C | 5 |
A | 6 |
B | -2 |
C | 5 |
A | 16 |
B | 1 |
C | 10 |
And then stack each matrix on top of each other (drag the visual), giving:
A | 10 | 6 | 16 |
B | 3 | -2 | 1 |
C | 5 | 5 | 10 |
(So you have three matracies here ^^ but it appears as if its just one. Select all three, right click and select group.)
Beacuse this is all in the same field as the date slicer the table auto updates as the user moves the slicer range. To add the colum headers you just add a text box. Go to format->bring forward, else the text box will fall behind the visual:
Start | Change | End | |
A | 10 | 6 | 16 |
B | 3 | -2 | 1 |
C | 5 | 5 | 10 |
As for filtering a measure in a seperate table to the slicer with no relationship present...No idea
I ended up creating three matrices in the orignal field. You can set the value to be "banded row style" for matrix data, giving:
(Column header added below)
A | 10 |
B | 3 |
C | 5 |
A | 6 |
B | -2 |
C | 5 |
A | 16 |
B | 1 |
C | 10 |
And then stack each matrix on top of each other (drag the visual), giving:
A | 10 | 6 | 16 |
B | 3 | -2 | 1 |
C | 5 | 5 | 10 |
(So you have three matracies here ^^ but it appears as if its just one. Select all three, right click and select group.)
Beacuse this is all in the same field as the date slicer the table auto updates as the user moves the slicer range. To add the colum headers you just add a text box. Go to format->bring forward, else the text box will fall behind the visual:
Start | Change | End | |
A | 10 | 6 | 16 |
B | 3 | -2 | 1 |
C | 5 | 5 | 10 |
As for filtering a measure in a seperate table to the slicer with no relationship present...No idea
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 |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
73 | |
50 | |
45 | |
20 | |
17 |