topic Power BI in Report Server

Power BI

Sobhan_1380 — Tue, 29 Apr 2025 08:04:33 GMT

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!

Re: Power BI

v-achippa — Tue, 29 Apr 2025 12:17:43 GMT

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

Re: Power BI

v-achippa — Fri, 02 May 2025 13:39:23 GMT

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

Re: Power BI

v-achippa — Mon, 05 May 2025 11:34:21 GMT

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

Re: Power BI

v-achippa — Thu, 08 May 2025 12:08:15 GMT

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

Re: Power BI

Sobhan_1380 — Sun, 11 May 2025 08:35:25 GMT

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?

Re: Power BI

v-achippa — Tue, 13 May 2025 05:04:44 GMT

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