Your measure mainly used a TOPN function, which will return a row in your formula instead of a value. I create a sample. Single or Bulk is a calculated column according to your description. In my understanding, you want to use Single or Bulk as a slicer and to calculate t...
Option 1: add a vertical line for the current week Option 2: mark the column with the current week with a different colour Please play around with the file by changing the values in the yellow marked cells. If this works, you should be able to copy it into your file and change...
Here another option with a small vertical line which shows the current week PascalKTeam Thanks for al your effort. I think it's a bug in Excel. Jeroen
In my understanding, you want to use Single or Bulk as a slicer and to calculate the Calculate the ShippedQty with the largest number of rows separately. Modify your formula to: Mode_ShippedQty = VAR _T = TOPN ( 1, ADDCOLUMNS ( VALUES ( ShippedOrders2022_Query[ShippedQty] ...
This seemed to work, but as soon as I use the slicer to select data, the lines of the graph are replaced by columns. Any suggestions to solve this? Jeroenadegraaf Please play around with the file by changing the values in the yellow marked cells. ...
Yes, the essence of my goal is to create visual which contains sales columns as usual, previous photo, also adding that new lines will be separated (the lines number depends on selected years in the slicer ( number of lines equal to number of selected years and so on.) How to...