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 Team,
have one question ..... how we can configure the below range in one measure , please check and guide me
<=3 hrs | 3-8 hrs | 8-12 hrs | 12-24 hrs | >24 hrs |
"
Thanks,
Krishna
Hi @MKM ,
We are bit unclear with your table structure where you capture the Hours data, so we have considered below table which holds hours value,
Also, the Slicer to filter these hours, we have created a table with options you mentioned as shown in below screenshot.
In order to filter the data based on selection you need to create a Measure in Data table with DAX expression as:
Filter Hours = SWITCH(SELECTEDVALUE(Hours[Hours]), "<=3 hrs", IF(SELECTEDVALUE(Data[Data Hours])<=3,"In","Out") ,
"3-8 hrs",IF(SELECTEDVALUE(Data[Data Hours])>3 && SELECTEDVALUE(Data[Data Hours])<8,"In","Out")
,"8-12 hrs",IF(SELECTEDVALUE(Data[Data Hours])>=8 && SELECTEDVALUE(Data[Data Hours])<12,"In","Out"),
"12-24 hrs",IF(SELECTEDVALUE(Data[Data Hours])>12 && SELECTEDVALUE(Data[Data Hours])<=24,"In","Out"),
">24 hrs",IF(SELECTEDVALUE(Data[Data Hours])>24,"In","Out")
This will check the selected value in the slicer i.e. filter and based on current value of table row validate the hours falls within selected range or out of the range.
Please refer to the below screenshot for the same.
Now in order to filter the table for respective data to be displayed in table as per the range selection we need to add filter to the table as Filter Hours = In as shown in the below screenshot.
If this answer helps, please mark it as an Accepted Solution so it would help others to find the solution.
Thanks!
Inogic Professional Service Division
An expert technical extension for your techno-functional business needs
Power Platform/Dynamics 365 CRM
Drop an email at crm@inogic.com
Service: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
42 | |
39 | |
19 | |
19 |