The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi Genious Community, I need one help from the community.
We have Customer Slicer and Time Period Slicer and 2-3 more slicers and the matrix in the page.
Problem: Whenever the user is selecting any customer and selecting the time periods from the slicers
for eg: Scenario 1. User is selecting All customers from customer group slicer and also selecting months from JAN 2022 to AUG 2022 from the slicer, so I want the measure to put in the Card visual to show this as YTD AUG 2022 - (YTD "MAax/latest selected month" "Year").
if user selects months from JAN 2022 to NOV 2022 from the time period slicer, then card should display "All Customers - YTD NOV 2022".
Scenario 2: When we are selecting months from DEC 2021 TO NOV 2022 (max selected month is Nov 2022 and going 12 months back i.e. Dec 2021) -- then this should display MAT NOV 2022 in the card visual And for eg: any customer is selcted from customer group name. Then, my card should display "Customer 1 - MAT NOV 2022"
Scenario 3: When user has selected multiple customers from the customer group slicer and also selecting 3 months from any Quarter for eg: he selects Qtr 2 2022 months - April, May and June. --- Then card shall display "Multiple Selections - Q2 2022".
I want these all scenarios to capture under one Measure so that I can put under Card visual. And depending upon the scenario - card should display selected values accordingly to the user to understand what he's looking at.
Any help would be really appreciated, Thanks-in-Advance!
Looking for the help!
https://powerbitalks.com/2020/06/powerbi-display-multiple-selected-values-card.html
https://www.sumproduct.com/blog/article/power-bi-tips/power-bi-displaying-multiple-slicer-selections...
I hope this helps.
@Amber_Dogra If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.
User | Count |
---|---|
15 | |
13 | |
9 | |
6 | |
6 |
User | Count |
---|---|
27 | |
19 | |
13 | |
9 | |
5 |