Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 @Anonymous ,
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/
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
8 |
User | Count |
---|---|
13 | |
12 | |
11 | |
10 | |
9 |