Forum Discussion
Filter by selected rows
Hi Denise_
I believe the following should be helpful
Using cross highlight with order and delivery date in Power BI - YouTube
In the video he got 2 fields in the fact, which he wants to compare (order date / delivery date). And so he can duplicate his DimTable (dimDate) for his relations. I can't implement this, because I only have 1 field for the relations.
In my case, my fact table looks like:
| Positionnumber | Month | Value | Value (bins 0.2) |
| 123 | 01.08.2023 | 10% | 0% |
| 456 | 01.08.2023 | 50% | 40% |
| 123 | 01.09.2023 | 40% | 40% |
| 456 | 01.09.2023 | 10% | 0% |
When i select the first bar in the histogram for August (0-20%), i wanna see the value of the Positionnr "123" in the second chat (filtered for September).
I tried arround to use the DimPositiondata for that and a measure with crossfilter like
CountCurrentMonthCross = CALCULATE(
COUNT( 'Positiondata'[Planposition]),
CROSSFILTER('Füllgrad'[Planposition], Positiondata[Planposition], Both),
'Füllgrad'[Month] = DATE(YEAR(today()), month(today()), 1),
'Füllgrad'[Value] >= 0,'Füllgrad'[Value] < 1
) CountNextMonthCross = CALCULATE(
COUNT( 'Positiondata'[Planposition]),
CROSSFILTER('Füllgrad'[Planposition], Positiondata[Planposition], Both),
'Füllgrad'[Month] = DATE(YEAR(today()), month(today()) +1, 1),
'Füllgrad'[Value] >= 0,'Füllgrad'[Value] < 1
)
But the second chart still gets filtered by the selected value of the x-axis when I select the first bar in the first chart.
I tried around with ALL(), ALLSELECTED(), REMOVEFILTERS(), etc. but this messes up the whole chart (all bars get the same size, etc.)
I uploaded a sample with less data to github
https://github.com/anybi/powerbiDenise_
Do you always have only two months?If so then you can rearrange the table as follows. In this case I see no need for dimTables but of course I don't have the full picture to fully judge that.
Please refer to attached sample file and let me in case this does not comply with your requirements.