Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dax expression to create static content on card using slicer

Suppose i have a info on card but when i select something in slicer the info will change on card but i dont want that i just want my info to be fixed. How it can be acheived?
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi Anonymous ,

     

    According to your needs, you can try the "Edit interaction" function in the Format window of the desktop. When I select the card marked 2 to not interact, when the slicer is filtered, the card marked 2 is always displayed as a fixed value. And the card marked as 1 will change with the change of the slicer.

     

    The specific reference is as follows:

    If you want to learn more about this feature, you can refer to the official document: Change how visuals interact in a report - Power BI | Microsoft Docs

     

    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.

StefanoGrimaldi's avatar
StefanoGrimaldi
Icon for Resident Rockstar rankResident Rockstar
5 years ago

if you want the actual dax measure you need to provide a example of the tables to write the dax, please read this topic about correcting posting a request for a better and correct response, post the table example with dummy data and then could write you the exact dax measure you need to create on your report for this. 

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1575553#M640781 

show what you trying to explain with pcitures here and the end result.