Forum Discussion
Need a Dynamic X-Axis
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?
2 Replies
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.
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 👍
