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.
Ability 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!
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.
Graphing a Column with Multiple Values in One Field
Hi, So I have a field that has multiple values captured in the column seperated by a comma. 3rdpartworks,encroachment,midas,sms,stakeholder,tenure encroachment 3rdpartworks,encroachment 3rdpartworks,encroachment,midas,tenure 3rdpartworks,encroachment,midas,sms,stakeholder,tenure 3rdpartworks 3rdpartworks 3rdpartworks .... I am wanting to be able to report it in a chart like below which counts the amount of times the value in the column. I have thought about what is the best way to approach this task. I was thinking that I could use power query just to split out all the values using the comma as the deliminator. Then I could count all the columns up and that would be the result. The only issue there is the ordering of the split out values. In one row, "3rd Party" could be the first value and in the next "Encroachment" could be the first value. Instead, I thought about using the "Card" widget and display the count of each value in a seperate widget but I don't like that option as much.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!
