Power BI Date Dimension: How to create it?
Are you using a dataset in Power BI that contains date fields which you need to use for analysis and creating reports? You need to use a Date Dimension in your model. A date dimension is an essential table in a data model that allows us to analyze performance more effectively across different time periods. It should be included in every dimensional model that contains a date or requires date intelligence as part of the analysis. In this session Shahab will introduce dim date and the necessity of using it and will explain how to create a dimension table in Power BI using different methods, including M Power Query, SQL script, DAX, Bravo Extension, and even the new tool ChatGPT. 𝙋𝙚𝙧𝙨𝙞𝙖𝙣 𝙋𝘽𝙄𝙐𝙂- 𝙈𝙞𝙘𝙧𝙤𝙨𝙤𝙛𝙩 𝘾𝙤𝙢𝙢𝙪𝙣𝙞𝙩𝙮: https://bit.ly/3IAg7xT 𝙇𝙞𝙣𝙠𝙚𝙙𝙄𝙣: https://bit.ly/32tGkif 𝙏𝙚𝙡𝙚𝙜𝙧𝙖𝙢 𝘾𝙝𝙖𝙣𝙣𝙚𝙡: https://t.me/PersianPBIUG 𝙔𝙤𝙪𝙏𝙪𝙗𝙚: https://bit.ly/3hk20RL Language: Persian - Farsi
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?
