Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Desktop

Hi team,

can we make the table or matrix view in powerBI dynamic which change with respect to slicer selected for date selected and storeID selected for

Example:Totalsalesreport_YYYYMMDD_storeID.

When I export data it will give name in above format instead of data.

I have to create subscripton with this name to user.

Its urgent please give solution.

Regards,

Arundhati

Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi Anonymous ,

     

    According to your needs, you can create the following measure, and then add the three fields that need to be filtered to the slicer. I did a test, the reference is as follows.

     

     

    List of ID = 
CONCATENATEX ( VALUES ( 'Table'[Report] ), 'Table'[Report], "_" ) & "_"
    & CONCATENATEX ( VALUES ( 'Table'[Date] ), 'Table'[Date], "_" ) & "_"
    & CONCATENATEX ( VALUES ( 'Table'[storeID] ), 'Table'[storeID], "_" )

     

    Or try the following formula, depending on your data model:

    List of ID = 
CONCATENATEX ('Table','Table'[Report] & "_" & 'Table'[Date] & "_" &'Table'[storeID])

     

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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

1 Reply

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    5 years ago

    Hi Anonymous ,

     

    According to your needs, you can create the following measure, and then add the three fields that need to be filtered to the slicer. I did a test, the reference is as follows.

     

     

    List of ID = 
CONCATENATEX ( VALUES ( 'Table'[Report] ), 'Table'[Report], "_" ) & "_"
    & CONCATENATEX ( VALUES ( 'Table'[Date] ), 'Table'[Date], "_" ) & "_"
    & CONCATENATEX ( VALUES ( 'Table'[storeID] ), 'Table'[storeID], "_" )

     

    Or try the following formula, depending on your data model:

    List of ID = 
CONCATENATEX ('Table','Table'[Report] & "_" & 'Table'[Date] & "_" &'Table'[storeID])

     

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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