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!
DAX to return a column that has multiple filter criteria and multiple tables
Hi Good Day, I have a proper data set that involves three tables viz, 1)DataInvoice 2)Points 3)Factor I need a visual that shows Date column from Datainvoice,units column from datainvoice table multiplied with value column from Factor table. But the above can happen with few filter criteria as below 1)Date column from Datainvoice should fall between Start and End date of factor table and then return corresponding Value column 2)while filtering the above we should make sure that DBName-point-id from datainvoice should match DBName-point-id of points table which inturn looks for DBName-Utility in factor table and picks up the VALUE column This is how the relationship looks: I want the output to look like below in a visual File Portfolio performance Looking forware to your response Thanks in advance amitchandak Ashish_Mathur Greg FreemanZ Greg_Deckler
