User Profile
erikzimm
Regular Visitor
Joined 2 years ago
User Widgets
Contributions
- 1.1KViews2likes0Comments
Bar Line Chart: Line Sum Issue
Hi, I am trying to make a bar and line combo chart. My bars work fine but when I add the line to the chart, the line sums all data into one flat line by summing all the data in the column. This is monthly data for both the line and bars, and it is connected via a date table. A snip of the data can be found here: Table for Bars Table for Line Date Col1 Col2 Date Col3 Jan 2022 1.5% 3.5% Jan 2022 7.0 Feb 2022 2.5% 1.5% Feb 2022 3.5 Mar 2022 2.0% 2.0% Mar 2022 4.0 As said the bars look fine, coming from the "Table for Bars" Col1 and Col2. The issue arises when I add Col3 into the line y-axis, it takes the sumation of Col3 and uses that for every month (in this case 14.5), rather showing me Col3 value month to month. The end result is a clustered bar chart, and a flat line across it, when it should be a bar chart with the value from Col3 at every given month as the line. Note that the Date field being used to produce the end chart comes from the Date table, which both data tables are connected to on their respective date fields. PS: clicking "Don't summarize" does not work.Solved1.1KViews0likes4CommentsRe: Replace measure value with date slicer
Hi - a follow up. Is there a way to allow my x axis to only display the dates >= to the selected date? Based on the example above, the selected values work as intended per your suggestion, however my x axis will still display 1/1/2000, 1/2/2000, 1/3/2000 etc. So, if the selected date is 1/2/2000 (and therefore the value is 105.6), I want my x axis to exclude/slice out anything <= 1/2/2000.758Views0likes0CommentsDynamic X Axis - Selected Start Date
Hi, I have a line chart which uses a measure that is able to dynamically switch based on the users' selected date as the start date. My dates/data is monthly. I want the x axis to change with the selected start date . For example, if the user selects March 2014, I only want the x axis to display dates greater than or equal to March 2014. My line should update fine as it does now, just need to exlude those prior dates and I cannot figure out the DAX for it. Thank you for the help!Solved666Views0likes2Comments- 781Views2likes0Comments
Replace measure value with date slicer
Hi, I have a measure which is simply a division equation such as sum(value)/measure2 = final result. It works perfect, however the input on measure2 is a fixed number pulled (manually) from a data table where it has a Date field and the Value field. Simplified, it looks like this (it is daily data): Date Value 1/1/2000 102.4 1/2/2000 105.6 1/3/2000 107.3 I have a date slicer, which slices my chart based on the data above, also no issues with this. The division equation previously stated is as follows: sum(value) / measure2 where measure2 = 102.4. What I want to know is how to allow the Date slicer to auto update measure2 to the new minimum value selected by the user. For example, the date slicer defaults to 1/1/2000 based on the data but if the user changed it to 1/3/2000, I want measure2 to not be 102.4 but 107.3 and thus produce a different result in the final result equation.Solved825Views0likes3Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.