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,
But can you combine lines for the labels with a column for the current week? Or a vertical line for the current week? Because I have about 90 labels in my graph and columns don't give good visual result. The 90 labels are also the reason I need the slicer. Jeroen...
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 th...
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","kudosSumWeight":0,"postTime":"2020-01-10T05:04:07.085-08:00","images":{"__typename":"AssociatedImageConnection"...
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 Jeroenadegraaf I'm working a lot with combined charts so hopefully, I can help you solve the problem. ...
Just change value in J2, refresh the pivot table and you will see. current week.xlsx47 KB Like 0 Reply Jeroenadegraaf Copper Contributor to PascalKTeamJan 15, 2020 PascalKTeam Can you take a look at the attached file and the way it responces when the slicer is used? Jeroen...
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. ...