calendars
7 TopicsCalendar Visual by MAQ Software
Hello, Anybody here uses the calendar visual by MAQ Software? I have another visual which is a table that displays the details of the event. When I click the date on the calendar, it is not filtering my table. Is there a configuration I need to do to make this work? It will be better if this calendar can filter other visuals.18KViews0likes12CommentsFree Calendar Visualization with Scrolling Functionality (Calendar Pro Alternative)
I am currently using the BCI calendar. It is depracated but still usable. The visual fits almost all of my needs, including: Shows one month at a time (not an annual view, customizable) Can expand into a rectangular view (a lot fo calendar vizs are sqaure) Allows you to use a measure (count) instead of each individual event Heatmap (I used a date table for the screenshot, which is why they are all the same hue) However, I also need the visual to: Allow you to scroll through multiple months within a date range. For example, if Jan-Mar is selected, showing Jan to start but having the option to scroll to Feb and March without changing the slicer. BCI would only show Jan, which isn't sufficient for my use-case The only other visual that fits all of the above criteria is the Calendar Pro by Okviz. This actually fits my needs better than BCI because of the ability to scroll month-to-month. However, I don't have resources for a license and the free version still asks for one once published. As stated, this visual meets all of my needs but I do not have funding for a license. Is anyone aware of a similar, free alternative?Same day Previous week DAX
Hi All, I have a table containing daily incident request raised by team members with columns - start date of INC, end date of INC, INC number, status, comments. Here, i need to build a report table showing date wise incident count and previous week count for each date. Eg: if today is 17/04/2023, then it should display count of incidents on that date along with previous week count. i.e. count of 10/04/2023 in same row. I have tried multiple dax formulas but nothing working. Either it returns day count or blank values. Please find attached image for reference.349Views0likes0CommentsM code for a DAX expression
Hi everyone, I need to transform this DAX expression in M: Week= YEAR(Calendar[Date]+26-WEEKNUM(Calendar[Date],21)) & "-" & IF(WEEKNUM(Calendar[Date],21)>=10, WEEKNUM(Calendar[Date],21), "0" & WEEKNUM(Calendar[Date],21)) which calculates the week of the year followed by the year for each date of my calendar, according to the European system: Can you help me? Many thanks!566Views0likes1CommentFormula to filter between two dates a table with a segment
Hello, Thanks to my two tables (Contract start date and Contract end date), from a hierarchy of dates (which is my segment which filters the entire page), I would be able to filter the users who are present at the within a society. I thought about creating a filter to select all users with a contract start date <= on the filter and all users with a contract end date> on the filter. If you also have an idea to change my segment on the page: a hierarchy from date to calendar because I haven't found. Can you help me with the formula please? Cordially.656Views0likes0CommentsCalendar Software by MAQ: Visual Customizations
I am a new user to MAQ Calendar application. So far so good, but the end user has requested some customizations that I have not been able to locate within the visualization settings. 1. Can the "Time" data be removed from the LIST view so it only reads the date and event? 2. I have identified how to REMOVE the week & day views- but can you make LIST view the DEFAULT? 3. Can you set the LIST view to START on Today's date vs starting on the first day of the month? Currently create a need to do a lot of scrolling to get to the current day if later in the month. 4. Can you prioritize which events appear first in a given day on the calendar view? Any guidance would be greatly appreciated! Thank you!1.6KViews0likes1Commentrelative fiscal QTR
Hi guys, I have created a relative date filter usings curbals video https://www.youtube.com/watch?v=gGNxKluPFNw Now i want to create on but for Quarter, the thing is PBI has QTRs set to jan to dec rather than November to October which is what i need , so we get a table like this when aplying this formula Relative QTR = DATEDIFF(TODAY(),'Calendar'[Full Date],QUARTER) month qtr Fiscal quarter qtr pbi 1 1 1 2 2 1 3 2 1 4 2 2 5 3 2 6 3 2 7 3 3 8 4 3 9 4 3 10 4 4 11 1 4 12 1 4 How can i set the Quarter to the range i want? ThanksSolved756Views0likes1Comment