Forum Discussion
Display column and row values for max
So I have an update:
I used this: https://www.excelnaccess.com/finding-the-column-name-with-max-or-min-value/
And that worked fine. But if I have a data set like mine (i.e. dates instead of apples and oranges) - how do I get the max value to vary when I change my filters (between months) in desktop?
Hi Anonymous ,
You can duplicate the table --> select [Kl. 1] to [Kl. 24] and unpivot the columns --> select [Dato] and Grouping --> Merge Query --> Expand Columns.
Result:
Such data is well reflected in the change of maximum values by creating line charts in the desktop.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
So I have an update:
I used this: https://www.excelnaccess.com/finding-the-column-name-with-max-or-min-value/
And that worked fine. But if I have a data set like mine (i.e. dates instead of apples and oranges) - how do I get the max value to vary when I change my filters (between months) in desktop?
Hi Anonymous ,
You can duplicate the table --> select [Kl. 1] to [Kl. 24] and unpivot the columns --> select [Dato] and Grouping --> Merge Query --> Expand Columns.
Result:
Such data is well reflected in the change of maximum values by creating line charts in the desktop.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum