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!
Representing Yearly Variance in Power BI Line Chart
Hi, I want to create a visual that shows the variance between the previous year's data and the current year's data in a line chart, similar to the attached image. In the visual, the black line represents the current year's data points for each month. The areas filled with green or red color represent the variance between the current year's data and the previous year's data. Green areas indicate months where the current year's data is higher than the previous year's data, while red areas indicate months where the current year's data is lower. How can I represent this in a stock visual in Power BI? I think we can do this using error bands or error bars, but I am not sure how to implement it. Currently, I am using a custom visual from Zebra BI, which I want to replace. Thank you. Visual example: The visual is a timeline comparison of all KPIs, showing the variance between the current year's data and the previous year's data. Here’s a detailed explanation: Line Chart Representation: The black line represents the current year's (CY) data points for each month. Each data point along the line corresponds to a specific month's value, marked with a numeric label (e.g., 6.8M for January 2021, 670.04K for February 2021). Variance Representation: The areas filled with green or red color represent the variance between the current year's data and the previous year's (PY) data. Green areas indicate months where the current year's data is higher than the previous year's data. Red areas indicate months where the current year's data is lower than the previous year's data. Axis and Labels: The x-axis shows the timeline from January 2021 to January 2022. Data Points and Variance: Each month has a labeled data point showing the current year's KPI value. The variance is visually represented by the shaded areas between the line and the baseline, with the color indicating the direction of the variance (positive or negative). Overall, this visual effectively shows both the current year's performance and how it compares to the previous year, highlighting significant increases or decreases with the colored areas.
How to force DAX measure to 0 in the same filter context
I have a measure calculating the sales amount and i'm placing it insiede a line chart with months on the x-axis, a field coming from a table called 'CALENDAR_TREND'. The chart is filtered by a slicer with months, field coming from another table called 'CALENDAR' linked to my previous table 'CALENDAR_TREND'. I want my chart to show values of sales amount, when the measure returns blank, as zeros but doing so mutates the chart filter context showing all the month of a year and placing 0 whenever the measure is blank or the month is outside the range selected with my month slicer. I just want the chart to show the range of months i selected with those having blank sales amount forced to zero. I already tried using ALLEXCEPT but i was not able to solve my problem. Example: I want the value of Sales PY to be forced as 0 in the month of August. If i put a new DAX measure usign ALLEXCEPT and add +0 to the calculation of the sales amount, i'll get a chart with months from Jan to Dec even if i filter those values out. Any clues will be appreciated, THANK YOU! 🙂
Infographic Designer scrollbar jumps back to start
Hello Power BI Community, we are using Infographic Designer 1.9.7 for visualizing line charts like the following: These charts have many values included, so a scrollbar gets activated. So far, so good. We have six of these line charts in one dashboard, and now the following problem occurs: When scrolling to the end of one data series within a chart, it is not possible, to scroll to the end of another data series within another chart. Both scrollbars jump back to the start of the data series. Does anyone of you know this problem? Is there a solution available? Best regards & thanks in advance!
