Forum Discussion
dynamic x axis
- 1 year ago
Ashish_Mathur FBergamaschi
Thanku so much for the reponse
I came up with one solution and it working now.
I am using two chart on chart for monthly and second one for the rest of the slicer.
showing chart when monthly selected and hiding it if other are selected.
Just used two measure for this and used visual lever filter.
Once again thank you for the reply.Chart A Visibility =VAR _Trend = SELECTEDVALUE('Trend_Type'[Trend])RETURNIF(_Trend = "Monthly",0,1)Chart B Visibility =VAR _Trend = SELECTEDVALUE('Trend_Type'[Trend])RETURNIF(_Trend = "Monthly",1,0)
I confirm you need a field parameter
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Please include, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. Do not include sensitive information and do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided and make sure, in case you show a Power BI visual, to clarify the columns used in the grouping sections of the visual.
Need help uploading data? click here
Want faster answers? click here
Ashish_Mathur FBergamaschi
Thanku so much for the reponse
I came up with one solution and it working now.
I am using two chart on chart for monthly and second one for the rest of the slicer.
showing chart when monthly selected and hiding it if other are selected.
Just used two measure for this and used visual lever filter.
Once again thank you for the reply.