Forum Discussion

KMcCarthy9's avatar
KMcCarthy9
Icon for Helper V rankHelper V
6 years ago
Solved

Mutli-Row Card - Show current month when nothing else selected

I have a visual and a multi-row card. When a month is selected in the visual, I have the multi-row card filtering to that month. However if no month is selected is there a way to make the multi-row c...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, KMcCarthy9 

    Based on your description, I create a measure as follows.

     

    TestMeasure = IF(CALCULATE(COUNTROWS('PM Table'),ALL('PM Table'))<>CALCULATE(COUNTROWS('PM Table'),ALLSELECTED('PM Table')),1,IF(SELECTEDVALUE('PM Table'[Month PM Due])=FORMAT(TODAY(),"MMMM"),1,0))

     

    Result:

    If I misunderstand the your thoughts, please show us your  expected output. I am glad to solve the problem for you.

     

    Best Regards,

     

    Allan

     

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

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
6 years ago

KMcCarthy9 

 

Ok, that’s what I thought. Check out the file I posted. I have set the interactions between visuals to produce what you need.

 

KMcCarthy9's avatar
KMcCarthy9
Icon for Helper V rankHelper V
6 years ago

Thanks PaulDBrown, now I see what you were saying. Ultimately, I think I have to change up my visuals, because I want the numbers in the multi-row card to change according to the selection made in the worktype slicer, but not the month. I don't think that is possible with my current visuals. 

 

Thanks for your help!