Forum Discussion
Max Values for the data that makes up a visualisation
Hi there,
Below is a visualisation I have and the underlying data of that visualisation.
Is there a way to show the max values only in the table to show which week the max is hit.
So there woud be 4 lines, 2 for Sydney and 2 for Vancouver in the table output.
One of the lines for example would be 03/10/22 Houdini Core 66.40 Sydney as that is the first week it hits the maximum.
I thought I could just display the underlying table as a visualisation and show the Max but alas that is not the case.
6 Replies
Anonymous , In line visual, you do not have option secondary line with legend.
One way is you create measure for license , then you can get max measure like to
calculate(maxx(values(Table[Date]), [Your measure]),filter(allselected(Table), Table[license] = max(Table[license]) && Table[license] ="Houdni"))
and add additional lines
Anonymous , Let's check with parry2k .
Parry, Any idea's for this
Anonymous yes mockup data with the expected result will help to provide the solution.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Basically What I want is a measure that would have 4 lines in it.
I want to know the week when the most of a license is in use for a location.
So it would sum on a week by week basis and come up with a total per week per location for the two different license types (Houdini FX and Houdini Core)
So the four lines would be
Location, Date, License, Max of LicenseTotal
So for this data
Sydney 02/05/22 FX 30
Sydney 16/05/22 Core 69
Vancouver 25/04/22 FX 19
Vancouver 02/05/22 Core 44
Location Craft Date License LicenseTotal Sydney Char FX 25-Apr-22 Houdini FX 18 Sydney Char FX 25-Apr-22 Houdini Core 8 Vancouver Char FX 25-Apr-22 Houdini FX 9 Vancouver Char FX 25-Apr-22 Houdini Core 3 Sydney FX 25-Apr-22 Houdini FX 8 Sydney FX 25-Apr-22 Houdini Core 4 Vancouver FX 25-Apr-22 Houdini FX 10 Vancouver FX 25-Apr-22 Houdini Core 3 Sydney Surfacing 25-Apr-22 Houdini Core 44 Vancouver Surfacing 25-Apr-22 Houdini Core 33 Sydney Char FX 2-May-22 Houdini FX 20 Sydney Char FX 2-May-22 Houdini Core 10 Vancouver Char FX 2-May-22 Houdini FX 7 Vancouver Char FX 2-May-22 Houdini Core 5 Sydney FX 2-May-22 Houdini FX 10 Sydney FX 2-May-22 Houdini Core 6 Vancouver FX 2-May-22 Houdini FX 9 Vancouver FX 2-May-22 Houdini Core 4 Sydney Surfacing 2-May-22 Houdini Core 48 Vancouver Surfacing 2-May-22 Houdini Core 35 Sydney Char FX 9-May-22 Houdini FX 19 Sydney Char FX 9-May-22 Houdini Core 5 Vancouver Char FX 9-May-22 Houdini FX 6 Vancouver Char FX 9-May-22 Houdini Core 3 Sydney FX 9-May-22 Houdini FX 8 Sydney FX 9-May-22 Houdini Core 3 Vancouver FX 9-May-22 Houdini FX 8 Vancouver FX 9-May-22 Houdini Core 3 Sydney Surfacing 9-May-22 Houdini Core 37 Vancouver Surfacing 9-May-22 Houdini Core 35 Sydney Char FX 16-May-22 Houdini FX 18 Sydney Char FX 16-May-22 Houdini Core 12 Vancouver Char FX 16-May-22 Houdini FX 6 Vancouver Char FX 16-May-22 Houdini Core 2 Sydney FX 16-May-22 Houdini FX 8 Sydney FX 16-May-22 Houdini Core 10 Vancouver FX 16-May-22 Houdini FX 9 Vancouver FX 16-May-22 Houdini Core 5 Sydney Surfacing 16-May-22 Houdini Core 47 Vancouver Surfacing 16-May-22 Houdini Core 28
