Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Stacked column chart

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...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    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!!

rajendraongole1's avatar
rajendraongole1
Super User
2 years ago

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!!