Forum Discussion

D4life's avatar
D4life
Regular Visitor
2 years ago
Solved

Parameter fields display only data for the current month by default

I created a table with parameter fields. There are about 30 different columns in the parameter filed. I want the table to only should records for only the current month. Then when the date slicer is ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi D4life 

     

    I understand your needs, please try the following ways:

    “Table”

     

     

    Delete the relationship between two tables.

     

     

    Create a measure. If the date matches the selection in the slicer, it is marked as 1, otherwise 0. If slicer is not selected, mark the day date as 1.

     

    Measure Parameter = 
VAR _SelectDate = VALUES('Date'[Date])
RETURN
IF(
    ISFILTERED('Date'[Date])
    && 
    SELECTEDVALUE('Table'[Date]) in _SelectDate,
    1,
    IF(
        NOT(ISFILTERED('Date'[Date]))
        &&
        SELECTEDVALUE('Table'[Date]) = TODAY(),
        1,
        0
    )
)

     

    Apply this measure to the filters pane.

     

     

     

    Create a table visual.

     

     

    Here is the result.

     

     

     

    Regards,

    Nono Chen

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

     

     

     

     

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi D4life 

 

Thank you very much lbendlin for your prompt reply, please allow me to share some content here.

 

Here's some dummy data

 

"Table"

 

Create a New Date Table. And create a relationship based on date columns.

 

Date = CALENDAR("7/1/2024", TODAY())

 

 

Create a measure. Determines whether to select a date for filtering. By default, the parameter field only shows data for the current month.

 

Measure Parameter = 
IF(
    ISFILTERED('Date'[Date]),
    CALCULATE(
        SELECTEDVALUE('Table'[Parameter]),
         FILTER(
            ALL('Table'),
            'Table'[Date] = SELECTEDVALUE('Date'[Date])
         )
    ),
    IF(
        SELECTEDVALUE('Table'[Date]) = TODAY(),
        SELECTEDVALUE('Table'[Parameter])
    )
)

 

Here is the result.

 

 

 

Regards,

Nono Chen

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

 

D4life's avatar
D4life
Regular Visitor
2 years ago

Thank you for your response. In my case the date column has repeated dates. Just like a normal transaction data would have. I noticed your solution had both columns unique. In my case both are not Unique. At least the date column is not unique.
Please assist with any suggestion