Showing static weeknumbers in "Line and stacked column chart".

[Anonymous]

Hello all,

My performance sheet is working pretty well, thanks to the people of this forum.

Now i would like to see also the performance by week over a whole year by a "Line and stacked column chart".

Shared Axis:

Shows the Weeknumber.

Column Values:

"Should" show me the performance(Score) for that week.

Line Values:

Shows the expected performance.

I thought i could just drop the same measure of the "Uw Score Op Tijd" visual to show this Score on the week in the "Line and stacked column chart". This does not work.

The measure for "Uw Score Op Tijd" = 

Performance pre = divide([Telling Acties Op Tijd],[Totaal Laad/Losacties])

Can some one tells me how to show this?

Besides when i am using the date filter on the other page, the weeknumbers changes also.

These weeknumbers should not be able to change.

The nicest should be, when i could see every week for about one year even the weeks in the future.

So on this page i would see:

1) The visuals above (grey background) do should be changeble by the filter of the other page by selecting a single week.

2) "Line and stacked column chart" shows every week in 2021, with the prformance by week.

Is this possible?

Thanks

[v-angzheng-msft]

Hi, @Anonymous 

---

So on this page i would see:

1) The visuals above (grey background) do should be changeble by the filter of the other page by selecting a single week.

2) "Line and stacked column chart" shows every week in 2021, with the prformance by week.

---

Does my way above work?, I think your requirement can be achieved by editing the slicer interaction. Please correct me if I didn't understand you correctly. Using the filter pane to act on the visual level I think would work just as well, but not as easy to select as the slicer. Not sure if this will work for you, here is my attachment.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello v-angzheng-ms,

The extra hidden filter on the page does indeed shows me the weeks in the chart.

But when i am using the filter on my filter tab, this will changes my filter on the Data Tab also.

I can shut this off with Sync slicers, but than i can not change mynumber charts on the Data Tab.

So i need 2 different Data filters on 1 tab.

Now i am writting this, i am thinking should it be a solution when i am making a second "date column" ?

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

I think there needs to be these fields present here.
Date, Week, Value, Expected Value, and any other metrics you need.
Then use the week number as a slicer to control the change of the card object in the gray background. Then edit the week slicer interaction so that the slicer does not act on the Line and stacked column chart. In this way, the slicer can be used to control the change of the card without changing the number of weeks in the whole year.

Sample:

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.