Issue with Date slicer - Fixed date regardless of selected date

[radule987]

Hi dear people, I have following problem:

Problem: I have three tables (WrittenPremiumSnapshotDate, ClaimBook, and DateDimension) connected as follows:

• LastDayOfMonth (DateDimension) 1:* ClaimBook_Date (ClaimBook)
• LastDayOfMonth (DateDimension) 1:* Datum_help (WrittenPremiumSnapshotDate)
• ClaimBook_Date (ClaimBook) : Datum_help (WrittenPremiumSnapshotDate)

When I select a date (e.g., 31.03.2024) in the Date Slicer (LastDayOfMonth), I need the rows in WrittenPremiumSnapshotDate where Datum_help is 31.03.2024 and rows in ClaimBook where ClaimBook_Date is also 31.03.2024 to appear. The issue is that in WrittenPremiumSnapshotDate, alongside the selected date, rows where Datum_help is 31.03.2023 must always appear because I use certain measures for the WrittenPremiumSnapshotDate table visual. How can I achieve that?

[radule987]

Hi @Anonymous ,

I managed to fix the measure to apply the MAX value (latest date) for the ClaimBook table. My question is: is there a way to automatically select 31.12.2023 (as shown in the screenshot, red colored date) for the WrittenPremiumSnapshotDate table without me having to click it? I want to be able to select a single date (e.g., 30.06.2024) on a slicer, and when I do, rows from the WrittenPremiumSnapshotDate where the dates are 31.12.2023 and 30.06.2024 would be visible, alongside only rows from the ClaimBook where the date is 30.06.2024. Also, this measure Likvidirane štete RSDDD is showing total value for all rows instead of sums for each row, how can I fix that? The column 'Proizvod (izveštaj 1)' is from third table called Dim_ProductMarketingName.

Here is the measure:

Likvidirane štete RSDDD =

VAR SelectedDate = MAX(WrittenPremiumSnapshotDate[Datum_help])

RETURN

SUMX(

    FILTER(

        ClaimBook,

        ClaimBook[ClaimBook_Date] = SelectedDate

    ),

    ClaimBook[ClaimBook_LiquidationSumInRSD]

)

Thank you.

[Anonymous · Accepted solution]

Hi @radule987 

Q1: Please try the Preselected Slicer:

Preselected Slicer (microsoft.com)

You can find the Slicer in the Get more visuals:

Here I create a set of sample:

If I want to preselect the 2023-1-1, we can add a measure:

Measure = 
IF(MAX('Table'[Date])=DATE(2023,1,1),TRUE(),FALSE())

Then add a new table:

Table 2 = {True,False}

You can change the value of this slicer, which can then be reset via the button in the top right corner.

Q2: You can use the ALLSELECTED() function to show total value for all rows:

Likvidirane štete RSDDD =
VAR SelectedDate =
    MAX ( WrittenPremiumSnapshotDate[Datum_help] )
RETURN
    SUMX (
        FILTER ( ALLSELECTED ( ClaimBook ), ClaimBook[ClaimBook_Date] = SelectedDate ),
        ClaimBook[ClaimBook_LiquidationSumInRSD]
    )

Here is a link for your reference:

Understand the Filter Context and How to Control i... - Microsoft Fabric Community

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[radule987]

Thanks, first problem is solved but I still get the totals for the second issue, with measure. 

[radule987]

Everything is working properly, relationship connection was not good. Thanks!

[Anonymous]

Hi @radule987 

What measure do you use for the WrittenPremiumSnapshotDate table visual?

Do you mean that when you don't select the 31.03.2024, the WrittenPremiumSnapshotDate also show the 31.03.2024?

If possible, please share your raw data(exclude sensitive data), or create some sample data, so that we can help you better.

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.