Showing working day no instead of calendar
Hello, i am facing a challenge where i want to have a bar chart showing daily invoiced sales, but instead of showing calendat day no number on x-axis i want to replace it with working day no. Data model setup: Base model: Tabular (storage mode: mixed) tables and dimensions used: 'Calendar'[ID] - linked to transaction table through a many to one relationship 'Calendar'[day no] - this is what i currently use on my x-axis. This is simply showing day number 1-30 depending on the selected fiscal year and fiscal month 'Calendar'[Fiscal Year] - used in dropdown to filter on fiscal year. runs from 1 july - 30 june 'Calendar'[Fiscal Month] - used in dropdown to filter on fiscal month. runs from 1 july - 30 june 'Global Measures'[Invoiced Amount] Requirements: Create a field to the calendar table return Working day no depending on the selected fiscal year and month. Working day counts as monday-friday, weekends is NOT a working day. Also public holidays should also not be taken into account. Working day should start counting from the first weekday of the filtered month and start over when a new month begins. Ideally, when using the field on the visual, weekends should be blank. I have tried to illustrate my idea through the snapshot below. The grey bars represent saturday and sunday to clearly distinct weekdays and weekends. So far i havent been able to find a working solution, so i am trying my luck making a post here. If there is any information needed regarding the data model or relationships etc. i will try to elaborate, just let me know.
Previous Year Measure for Line Chart
Hello. I am trying to create a YOY cumulative active customer by month line chart. The line should show the number of customers who made at least one purchase. One for Selected Year and another for Selected Year - 1. And, the total is rolling, so the line should be going up over time. Because there is a year filter in play, I am having difficulties writing a measure that provides a PY Active Customer line for the line chart. If I have 2026 selected, previous years' active customers is reduced. So, I have to removefilter the Calendar. However, this causes the PY active customer line ignore the month on the X axis resulting in a flat total line. Please help me write a measure that accurately calculates PY active customers and still works in a line chart. Should look something like this: Sample file here. Thanks.
No scrollbar at the x-axis
Hi Community, I've got the following X-axis (no scrollbar), but when I choose EOMONTH, the datapoints don't represent the actual graph. Is it possible to create a line-chart visual without a scrollbar, but with actual weeks, like 2020-18 - 2020-19 etc. etc. The format of the week is text and 2020-18 / 2020-19. When I try to make this number/date, for example 202018; between 202052 and 202101 there is a lot "white"space; In excel you can take the labels and there it is. Here, in PBI I find this very hard. Can someone help me? Thanks!Free 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?
Calendar Visual by MAQ Software: Highlighting today issue
Hi, I have a calendar page with 2 calendar by MAQ visuals. Both visuals use the same data but with different filter conditions. Today is May 17th, and on the top visual, the box for 17th May is not highlighted but on the bottom visual, today's box is highlighted yellow. How can I get this to be done across all calendar by MAQ visuals?
