Forum Discussion

Kumar_0606's avatar
Kumar_0606
Helper I
1 year ago
Solved

How to create a Parameter to display data dynamically

Hello Experts,   I have a date field. I want to display data dynamically so that whenever User selects particular date, data should be filtered accordingly. I created a Date parameter (transform d...
Need Help
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi Kumar_0606,

     

    Based on your requirement, the only reliable and supported approach for dynamic filtering like this is by using a Disconnected Date Parameter Table with Dynamic Measures.

    Here the SELECTEDVALUE(ParameterDate[Date]) returns blank because the slicer uses a formatted MonthYear column that maps to multiple dates. This leads to multiple values being selected behind the scenes and SELECTEDVALUE does not return a value in such cases.

    • So please create a seperate MonthSelector table with one row per month like for example 01 Jan 2025, 01 Feb 2025.
    • Use the MonthYear column from this table in a single select slicer and update your DAX measures to use the selected MonthStart date from the MonthSelector table.

    This will make sure accurate dynamic filtering using disconnected tables and give full flexibility to create CM, PM, PY flags in measures.

     

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Community Support
1 year ago

Hi Kumar_0606,

 

As we haven’t heard back from you, we wanted to kindly follow up to check if this solution resolved your issue? 

 

Thanks,

Anjan Kumar Chippa

Kumar_0606's avatar
Kumar_0606
Helper I
1 year ago

I tried the solutions mentioned here however didn't work.

I can't create a simple slicer because I don't have a direct field in the table

  • v-achippa's avatar
    v-achippa
    Community Support
    1 year ago

    Hi Kumar_0606,

     

    Based on your requirement, the only reliable and supported approach for dynamic filtering like this is by using a Disconnected Date Parameter Table with Dynamic Measures.

    Here the SELECTEDVALUE(ParameterDate[Date]) returns blank because the slicer uses a formatted MonthYear column that maps to multiple dates. This leads to multiple values being selected behind the scenes and SELECTEDVALUE does not return a value in such cases.

    • So please create a seperate MonthSelector table with one row per month like for example 01 Jan 2025, 01 Feb 2025.
    • Use the MonthYear column from this table in a single select slicer and update your DAX measures to use the selected MonthStart date from the MonthSelector table.

    This will make sure accurate dynamic filtering using disconnected tables and give full flexibility to create CM, PM, PY flags in measures.

     

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa

  • v-achippa's avatar
    v-achippa
    Community Support
    1 year ago

    Hi @Kumar_0606,

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if this solution resolved your issue? or let us know if you need any further assistance.

     

    Thanks,

    Anjan Kumar Chippa

  • v-achippa's avatar
    v-achippa
    Community Support
    1 year ago

    Hi @Kumar_0606,

     

    We wanted to kindly follow up to check if the solution resolved your issue? or let us know if you need any further assistance.

     

    Thanks,

    Anjan Kumar Chippa