Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.
Hello everyone,
I have two slicers (Slicer 1 and Slicer 2) and a card visual in my report. When both slicers are selected, the card displays a numeric value. However, when either one or none of the slicers is selected, the card shows the message: "Please select both Slicer 1 and Slicer 2."
Now, I want the font size of the message to be smaller when the text is displayed, and the font size of the number to be larger when the numeric value appears.
Is there a way to achieve this?
I’d appreciate any guidance!
Hi @Sobhan_1380,
Thank you for reaching out to Microsoft Fabric Community.
Currently, power bi does not support dynamic font size changes within a single card visual based on slicer selection. But we can achieve the required behavior by using two separate card visuals, one for the numeric value and another for the message and overlaying them in the same position.
Use DAX measures to return either the numeric value or the message based on slicer selections and return blank otherwise. This way only one card will show at a time, simulating a dynamic font size change.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
Hi @Sobhan_1380,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Thanks and regards,
Anjan Kumar Chippa
Hi @Sobhan_1380,
We wanted to kindly follow up to check if the solution I have provided for the issue worked.
If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Thanks and regards,
Anjan Kumar Chippa
Hi @Sobhan_1380,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked.
If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Thanks and regards,
Anjan Kumar Chippa
Hi @v-achippa
Thank You for your reply.
forgive me for delay in responding.
it's good idea that use two seprated cards instead of one, but it's not commen and useful solution.
we can write "Please select both slicer" in title of card visual. i prefer this solution.
what do you think about that?
Hi @Sobhan_1380,
Yes, you are right, using a dynamic title to show a message like "Please select both slicer" is a good solution, especially when the space is limited. It works well if the main goal is just to guide users rather than control the styling (like font size).
Using two separate cards is useful when you need to clearly separate the number from the message for example, by using different font sizes, colors or formats. But if you just want to show a message without changing the layout or styling, then using a dynamic title is definitely more practical and user friendly.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
4 | |
4 | |
3 | |
2 | |
2 |