Gordon has attended:
Power BI Modelling, Visualisation and Publishing course
Selective Cluster Chart Max Readings
Is there a way just to show the highest reading bars in a clustered column chart per x-axis time range, leaving out all the other readings/bars?
I have emailed a screenshot of the chart to STL for their reference purposes.
RE: 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
RE: Selective Cluster Chart Max Readings
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
