The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi everyone
Could i please get some assistance?
I have some dummy data below, in essence we have a users table, a user login table and a date table (relationships shown in the second snapshot). The users highlighted in yellow below are the users registered in the selected date range
The date table is used in the report as below. I want to add a filter/slicer to say if the user was registered during the selected filtered date or not. So a simple checkbox stating Yes or No (if the user was registered during the sliced date range)
Is this possible?
Thanking you in advance
Sammy
Hi,
Try to create a measure : if(max(User,registration date)=selectedvalue(date table, date),"Yes","No"). Plot this measure in a Marix.
User | Count |
---|---|
25 | |
10 | |
8 | |
7 | |
6 |
User | Count |
---|---|
32 | |
12 | |
10 | |
10 | |
9 |