Need a Dynamic X-Axis

[Igotzepowerbi]

In PowerBI I have a line chart with Month and Grouping (Grouping is Monday-Wednesday, Thursday-Friday and weekend) in the Y-axis I have a measure "AVG = CALCULATE(AVERAGE(ProPlusUsageUserCounts[Count]))" I am wanting a toggle that will update my x-axis between Grouping and Day of Week Name. Can someone help me please?

[Idrissshatila]

Hello @Igotzepowerbi ,

yes as said , you could do that using field parameters.

learn more about field parameters https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[datawailor]

Simply create a felds parameter, with the Day of week and Week Name in your selections, and then crate a chart place the parameter where you'd normally put your date field and it shouldchang the grain of the chart based on your selection.