Distance-Based Location Highlighting
Hello, I’m trying to calculate the distance between the assigned location and the employee’s home location using the latitude and longitude available in this file. The objective is to identify locations that are within the selected distance range (in kilometres) using a kilometre slicer. I would like the locations that fall within the selected range to be highlighted in green, while all other locations remain grey. Additionally, I would like the selected location to be highlighted based on the selected City, Employee Location, or StoresDummy[City] value. I’ve also referred to the following YouTube video for guidance: youtube Could you please help me implement this logic in Power BI/DAX? Sample data
single measure select multiple value shows in one graph
how to show three different values in one graph Redution buckts Ex Rate New Materials scrap values 0.7 0.17 0.45 0.7 0.27 0.35 0.7 0.17 0.45 Valueof Month Values Dec 2020 120 -> starting inventory Jan 121 feb 111 March 121 --> end inventory Graph should like below any idea . thanks in advance
How to remove Scientific Notation
In my table data looks like Scientific Notation.please find the screen shot. i have used below measure for the graph Total Month = IF(SELECTEDVALUE('Order Table Total'[Sno])="6.Total Month Variation",CALCULATE(SUM('Master Data Base'[Value]),ALLSELECTED('Order Table Total'[Sno])), SUM('Master Data Base'[Value])) how to trun off scientif notation in my report . i am trying to Format i am getting Error. Looking for support.the calendar it is not start with January, how to make work
Date1 = VAR MinYear = YEAR ( MIN('Date'[Date] )) VAR MaxYear = YEAR ( MAX('Date'[Date] )) RETURN ADDCOLUMNS ( FILTER ( CALENDARAUTO( ), AND ( YEAR ( [Date] ) >= MinYear, YEAR ( [Date] ) <= MaxYear ) ), "Calendar Year", YEAR ( [Date] ), "Month Name", FORMAT ( [Date], "mmmm" ), "Month Number", MONTH ( [Date] ) )
