Stacked column chart

[Anonymous]

Hi ,
I am using Stacked column chart in my report and using field parameters as a slicer with 10 parameters and using a disconnected table period with values selected period and Comparison period,in the X-axis I placed the columns with field  parameters and period,when I am trying to switch from one field to another field in the field parameters the visual is displaying totally blank but when I am removing and readding one of the fields in the X-axis ,the visual loading properly.

Any Suggestions?

Thanks in advance.

[rajendraongole1 · Accepted solution]

Hi @Anonymous - might be the issue is bacause of switching field parameters could be due to the interaction between the field parameters and the disconnected table used for the period.

Instead of using disconnected tables as you mentioned, you can create a dax measure to handle the selected period and comparison period using below logic, change the table name and columns as per your model designed.

Logic:

SelectedPeriod = SELECTEDVALUE(PeriodTable[Period])
ComparisonPeriod = CALCULATE(SUM(Table[Value]), FILTER(ALL(Table), Table[Period] = "Comparison Period"))

Check once your field parameter switch statement logic and fields been used.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!