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.

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

PaulDBrown 
Upon reading again, I don't think I explained my end goal very well. 

The multi-row card is showing the current month data now when nothing is selected, thanks to v-alq-msft solution.  However, if I choose a selection in the worktype slicer, the multi-row card goes back to showing all months. I would want it to stay on the current month, if no other month is selected. Does that make sense? 

Multi-row card = Always show current month, unless a month is selected in the column graph OR in the month slicer. Is this possible?

THANKS!

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!