Forum Discussion
Make a column not sum/count
I've used Power BI quite a bit lately with a SSAS cube and some Sql Server queries and created many visualiations. I am still fairly new to this though and cannot figure this out. I imported a ...
When I needed a chart to pick up the most recent value on a metric with daily values but didn't have a "don't summarize" option in the visual, I left it as Sum but added a Top N date filter to the visual, chose top 1 day and by value Latest date. Summing the most recent date's data with no other values did what I needed.
(Setting the column's default summarizaton to don't summarize didn't help, and I couldn't store the values as text since I needed them to drive a chart axis.)
I realize this is a very old question, and I'm not sure I understand OP's goal, but I wonder if michaeljc70's challenge would be solved by doing the visual filter trick using his period column.