Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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.
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.
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!
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
Proud to be a Super User!
Paul on Linkedin.
@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!
Ok, that’s what I thought. Check out the file I posted. I have set the interactions between visuals to produce what you need.
Proud to be a Super User!
Paul on Linkedin.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |