Dax expression to create static content on card using slicer

[Anonymous]

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?

[v-henryk-mstf · Accepted solution]

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.

[Ashish_Mathur]

Hi,

You may turn off interactions.

[StefanoGrimaldi]

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#M6407... 

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

[StefanoGrimaldi]

you will need to give more details, its too undefinied what you explain, basically you could do a measure with dax using filter or calculate accoding to your need to get the exact result you looking in the measure as if it was filtered with a slicer, 

[Anonymous]

suppose we are having two options on the slicer i.e., marks and grades. When we select marks visual card reflects the total number of marks, when we select grades it shows the grade.  I want marks to be displayed on the visual card irrespective of the selection done on the slicer. 

[StefanoGrimaldi]

another option, go to edit interaction, make all slicer not to change that card, and on the filter pane for that card select the filters values as you need them to stay static, 

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions 

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-filter