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 all. I'm using the Timeline by Queryon visual to show the contents of a month-long course. I'd like to replace the Date field (under Date/Time in first screenshot), which includes weekends and holidays for ease of use by the authors of the source data, with a measure that only shows Dates that have a corresponding Class # (see 2nd screenshot), basically eliminating days with no class. Can't get my head around how to use FILTER and/or a conditional. Any advice out there?
Solved! Go to Solution.
Hi @Anonymous ,
Try the following measure:
Class=if(max('Curriculum'[Class #])=blank(),"no class",max('Curriculum'[Class #]))
If this could not solve your questions,could you pls share your pbix file?Remember to remove confident data.
Best Regards
Lucien
Hi @Anonymous ,
Try the following measure:
Class=if(max('Curriculum'[Class #])=blank(),"no class",max('Curriculum'[Class #]))
If this could not solve your questions,could you pls share your pbix file?Remember to remove confident data.
Best Regards
Lucien
Thanks @v-luwang-msft ! Yes, this works. I can't get my head around why MAX is the answer, but it definitely is.
Thanks @amitchandak.
I want a permanent solution and I think a visual level filter is impermanent, right? I'm a newbie, so possibly very wrong.
I tried this...
ClassDates = FILTER('Curriculum'[Date], RELATED(NOT(ISBLANK('Curriculum'[Class #]))))
@Anonymous , add a visual level filter class is not blank
or add that to measure filter not(isblank(Table[Class]))
Thanks again @amitchandak . While the measure didn't work for me (could be user error), the visual level filter does seem to be a totally valid solution and would have sufficed if @v-luwang-msft hadn't provided another option. Much appreciated.
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 |
---|---|
115 | |
100 | |
89 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |