cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
KMcCarthy9 Regular Visitor
Regular Visitor

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 card default to the current month?

I'm using the following measure to filter it to the selected month:
       MeasureToCheck = COUNTROWS(ALLSELECTED('PM Table'[Month PM Due]))


When a month isn't selected, the multi-row card is blank, but I would like it to show the current month. 
I have posted a pbix file here: pbix file 

Thanks for any information! 

1 ACCEPTED SOLUTION

Accepted Solutions
v-alq-msft Established Member
Established Member

Re: Mutli-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:

xx.png

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.

View solution in original post

6 REPLIES 6
v-alq-msft Established Member
Established Member

Re: Mutli-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:

xx.png

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.

View solution in original post

KMcCarthy9 Regular Visitor
Regular Visitor

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

Hi @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! 

PaulDBrown New Contributor
New Contributor

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

@KMcCarthy9 

 

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 Regular Visitor
Regular Visitor

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

@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 New Contributor
New Contributor

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

@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 Regular Visitor
Regular Visitor

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

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! 

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)