topic Data display in a chart (Bar or Combo) in App Development

Data display in a chart (Bar or Combo)

BI_Dev — Mon, 24 Feb 2025 15:55:12 GMT

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.

Re: Data display in a chart (Bar or Combo)

Ben_P — Mon, 24 Feb 2025 16:58:50 GMT

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.

Re: Data display in a chart (Bar or Combo)

MatheusC — Mon, 24 Feb 2025 17:11:28 GMT

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

Re: Data display in a chart (Bar or Combo)

Chanty4u — Tue, 25 Feb 2025 02:47:03 GMT

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])

)