Dynamic Year Measure
Jolly Day, I currently have my visual set to just give me year 2021. I am wanting it to automatically update go two years back so I need it set to year 2022 when we begin year 2024. Is there a way to accomplish this? I created a year column that just parsed the year from my date so we also have the full date to work with. Any help with this would be greatly appreciated! Thanks in advance, Idon'tquitegotthepowerBIHow to make a graph understand that the week number is next year (to make the date sort right)?
Hi, I have this data: And I have made this graph - which shows completed sales and expected future sales. This works great for when I use the "Date" field, but I want it on week level, and when I do that it looks strange (see picture below), because Power BI doesn't understand that week 1 is next year, and hence is after week 52. Is there a way to make it understand that week 1 is next year? And hence that the graph looks more similar to the one with "Date"? Thanks in advance, highly appreciate it 🙂Filter month year column to exclude future dates from today
I have a dates key table that runs from Jan 2018 - Jan 2021. I have a month year column (Text Format): Month Year = FORMAT('DimDate'[DateS],"MMM YYYY") However it pulls in all dates in the dates key range: Is there a way to exclude future dates from: FORMAT('DimDate'[DateS],"MMM YYYY"),<=TODAY() Thanks in advanceUK Fiscal Year Column
Hi, I am trying to create a Date format Table which has a column for UK fiscal year based on another column date. I have managed to do from 01 April - 31 March using month calcs but need the fiscal year dates to be 06 Apr - 05 Apr in acordance with UK fiscal year. The formula i have at the moment is as follows: Fiscal Year = IF(MONTH(Date_Reference_Table[Date])>3,YEAR(Date_Reference_Table[Date])&"-"&YEAR(Date_Reference_Table[Date])+1,YEAR(Date_Reference_Table[Date])-1&"-"&YEAR(Date_Reference_Table[Date]))
Bar chart by quarter including last quarter from previous year
Hi there, I currently have a report that shows me a selected year's metrics by quarter on a bar chart: However, I would like this view to also show me a bar for the last quarter of the previous year for comparison, that would still show up even if I have a page level filter for Year. For example: if I filter my page to the year of 2018, I still want to see the last quarter of 2017 on my bar chart, to the left of the 2018 quarters bars, ideally looking something like this: Is this possible? How can I achieve this or something similar that serves the same purpose? Thanks in advance!
