Forum Discussion
Helper VMutli-Row Card - Show current month when nothing else selected
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.
Helper VHi v-alq-msft ,
Thank you for this as I was able to get it working. However, I left out that this will be used a on a page with slicers, and when I make a selection in a slicer, the multi-row card again shows all months and does not default to the current month.
Is there a way to have the multi-row card default to the current month even when a selection is made in a slicer? I only want to change the month of the multi-row card when a month is selected in the column graph or a month slicer.
I have uploaded the file with slicers here: pbix file
Thank you for your help!
Community Champion
To stop a visual from being affected by slicers, all you need to do is set the visual's interaction to none (click on a slicer, and go to FORMAT in the ribbon, click on the otion edit interaction on the left).
I'm not completely sure what it is you are trying to achieve with the multi-row card. If nothing is selected, it is actually displaying values (whereas you mentioned in your original post that it was displaying blank).
Anyway, I have set up a Calendar Table and measures to allow for the mutli-row card to display values pertaining to the current month if no selection is made on the bar chart - month- or in a slicer (month). (please note that the way you have set up the data in the page is not fitering by year btw). As you will see, the multi- row card only responds to the month slicer or interaction with the bar chart.
Here is the PBIX File: Multi-Row PBIX
- KMcCarthy9
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
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
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!