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.
Hi,
I have a table of Opportunities. In there I have 2 columns - "CreatedOn" And "ClosedOn".
I have a Card containing count of new opportunities created (Ideally Controlled by "CreatedOn"), and another card showing Revenue of won Opportunities (Ideally Controlled by "ClosedOn".
It is possible to make a "combined" slicer, so If I select "Jan 2019", the "Opportunities Created" will be sorted by "CreatedOn" Jan 2019, AND the "Revenue of Won Opportunities" will be sorted by "ClosedOn" Jan 2019?
Hope it makes sense!
Solved! Go to Solution.
Hi @PeterStuhr
You may create the measures as below:
Opportunities Created = IF ( ISFILTERED ( 'Calendar'[YearMonth] ), CALCULATE ( COUNT ( Table1[Opportunities] ), FILTER ( Table1, Table1[Create] IN VALUES ( 'Calendar'[YearMonth] ) ) ) )
Regards,
Cherie
Hi @PeterStuhr
You may create a calendar table and make sure there's no relationship between the two tables.Use the YearMonth column as slicer.Then you may create measures as below.For further,please refer to attached file.
Opportunities Created = IF ( HASONEVALUE ( 'Calendar'[YearMonth] ), CALCULATE ( COUNT ( Table1[Opportunities] ), FILTER ( Table1, Table1[Create] = SELECTEDVALUE ( 'Calendar'[YearMonth] ) ) ) )
Regards,
Cherie
Thanks for your reply.
I am all new to Power BI, but I think I made it work when only 1 month is selected. However, if I do multiple month selections, I get a "blank". Any workaround?
Hi @PeterStuhr
You may create the measures as below:
Opportunities Created = IF ( ISFILTERED ( 'Calendar'[YearMonth] ), CALCULATE ( COUNT ( Table1[Opportunities] ), FILTER ( Table1, Table1[Create] IN VALUES ( 'Calendar'[YearMonth] ) ) ) )
Regards,
Cherie
Hello Cherie,
I used your solution and it is effective.
However, if some fieds are places I want to represent on a map, how should I do so that places and dates related?
Thank you and regards.
Initially I thought no it's not possible but apparently it is.
Only 1 active relationship but you can derive measures using the inactive relationships. The slicer won't work on multiple connections unfortunately.
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 |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |