Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Anonymous
Not applicable

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?

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

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:

v-henryk-mstf_0-1612937075449.png

v-henryk-mstf_1-1612937103633.png

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.

View solution in original post

6 REPLIES 6
v-henryk-mstf
Community Support
Community Support

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:

v-henryk-mstf_0-1612937075449.png

v-henryk-mstf_1-1612937103633.png

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
Super User
Super User

Hi,

You may turn off interactions.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
StefanoGrimaldi
Resident Rockstar
Resident Rockstar

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. 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




StefanoGrimaldi
Resident Rockstar
Resident Rockstar

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, 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




Anonymous
Not applicable

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. 

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 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.