Comparing values with the same date range
Hi Community I would like to get some help with a DAX measure. I want to have a bar chart like shown in the snippet, where i compare values from previous years, but my struggle is to have the same date range as my current year (in this case 2024/25) so in a month slicer i have selected september. this means that i have data from september 1st til september 17th. But my previous years shows the full month of september. How can i make sure it always follows the same range? how would a DAX measure look like to achieve this?
Compare data/calculations for a chosen month with same month last year
Hello there TLDR: Based on a chosen month selected with a slicer (custom "Timeline 2.4" slicer) to compare numbers with exact same month last year. So lets say the user selects April 2023, I also want to show data for April 2022, especially the difference in %. I've been searching and searching and tried different solutions without luck. So I have some electricity sensor data for lets say 3 years based upon this calculated measure: Calculated_consumption= (CALCULATE(SUM(Measurements[numericValue]), Measurements[field] = "consumption", Measurements[deviceid] = "X") / 1000). There are timestamp, date, month-year etc columns. I've tried with all columns refering to some kind of "date" or "timestamp"... When the user selects for example April 2023 the dashboards shows electricity consumption for that given month. But I also want a box showing the change from April 2022. So far I've only managed to create tables and graphs that can compare to previous month.. The solutions that didn't work for me: - X = CALCULATE(([Calculated_consumption]), DATEADD(Measurements[MonthYear],-1, YEAR)) - Y = CALCULATE([Calculated_consumption], SAMEPERIODLASTYEAR(Measurements[MonthYear])) - Z = CALCULATE([Calculated_consumption], PARALLELPERIOD(Measurements[MonthYear],-12,MONTH)) Thanks in advance
Compare values from 2 visualized tables in powerbi dashboard (NOT BACK END TABLES COMPARISON)
Hi there, I have a challenge for the expert powerbi community!! Within my company we are currently looking to compare two table values in the powerbi dashboard (FRONTEND) to return an marker wheter the individual green value (which is filtered by "studiegroep", "periode" & "voornaam") meets the groupbenchmark pink value (filtered by :"benchmarkyear" but with changing data based on a backend division of data). Using PowerQuery within the tables is not possible given the pink data is changing when using diffent filters (so the pink data is not directly from another back-end table but is only generated in the dashboard by using measures & filters in the dashboard. Normally in excell you would simply make a calculation based on the respective cells (see example below) and add a conditional formatting, see example in excell. However, I am looking for a similar solution within the powerbi dashboard. Is this possible in PowerBi? would love to hear from anyone who can offer help!
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!
