Calculating Year To Date and Full Year
Hi Community I am asking for your help with a DAX measure i cant seem to figure out how to put together. Here is what i require. I want to create a bar chart that could look similar to the snippet i provided. (it shows year to date values from current fiscal year 2024-25) and four years back. However, i want to create a DAX measure that shows year to date, for my current fiscal year, i have a measure for that, where it takes into consideration my month selected in a slicer. Anything that is not current fiscal year should return the full year and disregard the month. I hope someone can help me provide what the code would look like to achieve this.
Power BI Report Server - Hierarchy Axe Y impossible on bar graph
Hello everyone, Sorry for my approximate technical English, I hope the exposition of my problem will be understanding. Here is the version of : - my PowerBi Destock: Version: 2.109.1021.0 64-bit (September 2022) - my PowerBi Report Server: Version1.15.8377.1837(September 2022) I have a problem to go down in the data hierarchy on my Y axis in my PowerBi Report on a bar chart. On my PowerBi Destock : When setting up my bar chart, I defined a hierarchy for the Y axis based on a date table. On my chart, I can go down from month to week to day as set (on the top right corner). On my PowerBi Report : Once my PowerBi is online, when I open my PowerBi, I can't access the option to go down the bar chart (nothing on the top right corner). FYI, on a curved graph, I don't have this problem (with the same configuration). => Do you have any idea of the solution ? Thanks in advance for your help, Regards, ThomasAbility to create a measure based on selection for a visual OR use anotheslicer if none is selected?
Hi Everyone, I'm going to try my best to articulate what I'm looking for, but I have a bar chart where my x axis is fiscal years (last 10 years) and my Y axis is how much money was spent for each. I also have a gauge that shows total spent and paid visual as well. My issue I'm having is I want my gauge to default to this fiscal year we're in, but update if another fiscal year from the bar chart is selected. My problem i'm having is I dont know if there is a way to set it to default if nothing is selected. Right now with all the bar chart's FYs showing the gauge is totaling all of them up together which is inaccurate since our FYs act in silo's so I dont want mass total. So I want the guage to be this FY or adjust if a single year from the chart is selected and if nothing in the chart is selected then gauge goes back to the current FY. I'm hoping i'm making sense. Is this even possible? What I tried to do is add a FY slicer with today's FY as the first/default so that keeps the guage for this FY and turn off the bar chart to filter from that slicer, but then if i select a year from the bar chart to view the guage is blank. I am hoping there's a way to create a measure and reference the selected item from the chart otherwise use the FY slicer i added or something like that. Thank you!
Bar Chart Categories Not showing when data filtered.
Good morning everyone. I'm producing a bar chart to show discrete data. The output of machines. We have 12 machines and I would like to see the data for all machines even if zero. I have selected "show items with no data" and also put +0 to the end of the calculation. When I choose a large time scale filter on the visualisation . E.g year , all 12 machines data is visible. However I report on data from the previous working day. If those machines haven't been used in the previous working day. I'm struggling how to include a value of zero also. Appreciating anyones help .
Trying to CREATE percentage as tooltip when I Hover on bar graph
Here is the dataset: Year Type Value 2023 a 20 2023 b 50 2023 c 30 Here is the Visual: I want to see percentage when hover over a category: Here is how to make the visual: Here is the DAX I used to make the code: Measure = var a = sum('Table'[Value]) var b = if(HASONEVALUE('Table'[Type]), max('Table'[Value]) ) return b / a But the result does not show an accurate percentage when hovered: Expected result: 30/100 = 30% and not 100%
Selected Year Side By Side Comparison In chart
Hi guys, I want to create a bar chart or any other chart that will include loss ratio data from two selected years. (for example, if i choose 2020 and 2022 it has to show both of them side by side). The problem is when I create a single date slicer and choose both years there's no side by side comparison, it's just a dynamic visualization of it (as first screenshot shows). I want them to be side by side like next to 2019 qtr1 has to be second chosen year's first quarter results like its on the second screnshot. Loss ratio means Loss Amount divided by Sales Amount.Number value is adding to Chart as 'Count of'
I have a chart that looks like the below. When I convert this to a line and column, it automatically convert the 'PM Count' column to be 'Count of PM Count' and therefore displays the values incorrectly. Below you can see that field is clearly a numeric value and is formatted as such.
Axis value missing when report is saved to report server
Hi all. I have created a report in Desktop RS and all grouped values are displayed in axis (Stacked column chart): When I save this report in RS, the "2-3 AM" value is missing from axis and order is: 12-1 AM, 4-5 AM: What's wrong with this report? I have tried replacing this visual with other visuals having the same functionality, no luck.
