chart visibility to my organisation position

Power BI
1

Hi All

Unsure whether someone has come across the issue. i have a chart that shows 42 organisation including mine. the chart is sorted by highest to lower values. The annoyance is i want to chart to show the position of my organisation A without dragging the slicer to organisation A. I have tried every dax measure but the chart still shows the start of highest values instead of directly focussing on my organisation position. furthermore i have changed the dax measure bu now it shows my organisation as the starting point but all other organisations have same values? Opido1_ICB_COMBINED =
VAR BathValue =
CALCULATE(
SUM(Fact_Opiod1_ICB[Patients receiving opioid pain medicines per 1,000 patients]),
‘DIM_Region’[Prescribing Organisation] = “NHS Bath And North East Somerset, Swindon And Wiltshire Integrated Care Board”
)
VAR AllICBValue =
CALCULATE(
SUM(Fact_Opiod1_ICB[Patients receiving opioid pain medicines per 1,000 patients]),
ALLSELECTED(‘DIM_Region’[Prescribing Organisation])
)
RETURN
IF(
ISBLANK(AllICBValue) || ISBLANK(BathValue),
BLANK(),
BathValue
)

the original dax is Opido1_ICB = CALCULATE(
SUM(Fact_Opiod1_ICB[Patients receiving opioid pain medicines per 1,000 patients]),

DatesCalendar[MonthnYear])
2

Hi @zohra.belabed - May be try something like in attached PBIX.

Create a Rank Measure based on your aggregation and for your company give the RANK as 0.

> RankCustomer =
> var Rankval = RANKX(all(Customers[Customer Names]),[Total Sales],,DESC)
> return
> if(SELECTEDVALUE(Customers[Customer Names]) = "New Ltd",0,Rankval)

Put the Rank in the X-Axis along with base measure and sort by Rank ascending. So your Organization will show on first position, rest will be from Highest to lowest.

Mastering+DAX+Calculations±+Base+File_New.pbix (410.8 KB)

PS: Will need some customization. Also, if you are looking for something else then do clarify.

Thanks
Ankit J

1 Like