Data display in a chart (Bar or Combo)

[BI_Dev]

I have data as below - In the bar chart I want to show the Max of Total Badge-in only as  a dot - 

Measure expression is count(distinct Badge-in)/count(distinct days).How can I show max as a point in the same chart - Here it should show 9,902 on 'TUE' bar.

[Ben_P]

Change your chart to a combo chart, then add a new measure, something like the below, and display as marker:

if(
count(distinct Badge-in) =
max(TOTAL aggr(count(distinct Badge-in),[Weekday])),
count(distinct Badge-in)
)

This is saying, if your measure for any given dimension value is the same as the max value across all dimension values, then display it... so would result in a point for the day with the max value, and nothing for other days.

You may also want to display it on a secondary axis to ensure the bars still have a reasonable height.

[MatheusC · Accepted solution]

Hi,

Using the match chart, try the approach below with the pick function in conjunction with match:

pick(match(

                count(distinct [Total Badge-in]),

    max(total aggr(count(distinct [Total Badge-in]),[Badge Weekday])))+1,Null(),max(total aggr(count(distinct [Total Badge-in]),[Badge Weekday])))

Adjust according to your data.

- Regards, Matheus

[Chanty4u · Accepted solution]

Try this

If(Count(DISTINCT [Badge-in]) / Count(DISTINCT [Days]) =  

   Max(Aggr(Count(DISTINCT [Badge-in]) / Count(DISTINCT [Days]), [DayOfWeek])),  

   Count(DISTINCT [Badge-in]) / Count(DISTINCT [Days])  

)