Forum Discussion
Dax expression to create static content on card using slicer
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.
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.
Resident Rockstaranother 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