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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
BRL7WZ
Helper I
Helper I

Visualisation "Card" doesn't link to the new parameter

Hello All,

Could someone please help me solve this problem if possible.

I have a table in which there are products with expiry dates.

 

I filter the table using the slicer. I also have a 'Card' visualisation which shows me how many filtered products there are.

I have now additionally created a new parameter in which I can select which products expire in 15,30,45,60,75,90 days.

The problem lies in the fact that when I select, for example, which products expire in 15 days, the result in the table is correct, but the value of the 'Card' visualisation does not change.

Do you perhaps know what I should do in this case?

BRL7WZ_0-1699267487996.pngBRL7WZ_1-1699267509632.png

 

1 ACCEPTED SOLUTION

Hi @BRL7WZ ,

My pbix is below:

Best Regards,

Xianda Tang

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

4 REPLIES 4
BRL7WZ
Helper I
Helper I

Hi @v-xiandat-msft 

I'm sorry, but I have no idea how you came to that result. I have tried but failed. Each time...

 

Would it be too much on my part to ask you to send me this sample pbix? Then step by step I will try to implement this solution in my report.

 

Hi @BRL7WZ ,

My pbix is below:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-xiandat-msft 

Fantastic! Thank you so much for your help and support.

v-xiandat-msft
Community Support
Community Support

Hi @BRL7WZ ,

You can create a metric to put in the card

Below is my table:

vxiandatmsft_0-1699429597716.png

The following DAX might work for you

Measure 2 = 
   COUNTX('Table',[Measure])
Measure = 
  var days_to = SELECTEDVALUE('Table'[days to expire])
  var result = 
    CALCULATE(
      COUNTROWS('Table'),
      FILTER('Table' , days_to >= 'days to expire'[days to expire Value])
    )
   return result

The final output is shown in the following figure:

vxiandatmsft_1-1699429645584.png

Best Regards,

Xianda Tang

If this post helps , then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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