Selective Cluster Chart Max Readings

Hi Gordon,

Thank you for the forum question.

I do not know your data model and if the values come from a measure or a column range and I do not now if you are using a date table in the model.

If you get the values from a column range (not based on a measure), click on the down arrow next to the Y-axis box under the visuals in the visualization pane and change the calculation from sum to maximum.

If the values come from a measure create a new measure Max day value=Maxx(fact table name, name of the measure your values come from)


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Hi

You may also be able to use the filter pane and by use the Top N filter and set it to top 1 based on the value you use on the chart.

But again it all depend on your data model.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector