Straight table

[paulwalker]

Hi Community,

I have to create one chart with 3 measures and each months count in one chart. (I feel Pivot table not suitable for this, so used straight table)

I have used straight table (written all the expressions 3 measures and individual months like below)

Here calculations should be dynamic and when user select Mar'23 - chart should show Jan, Feb and Mar along with 3 measures. If user select Feb'23 - Chart should show Jan and Feb along with 3 measures..

let say user select Mar'23

Thanks in Advance!

[paulwalker]

@tresesco , any suggestions for better view instead of all individual months calculation ? 

[edwin]

my understanding is that you need to display some number of measures that arent turned on/off by the month selection and then you need to add as many measures that represent year to month (in individual months).  the way i would do this is 
1. create your 3 measures (no condition)
2. create 12 measures (Jan to Dec)
3. the labels would be of course dynamic based on the year
4. each would of course have its own expression to calculate just for the month and year
5. add a condition that if the month <= the selected month then turn it on else off

[paulwalker]

Thanks for reply Edwin, I'm unable to configure hide/show condition.

[edwin]

not sure what a 5-point condition is.   but thsi is what i am saying:

this assumes that the data is only for one year starting from Jan
wht i did was add a MonthText Jan to Dec:

the user selects the Month 
then for the 12 months my expression is:
Sum({<Month=, MonthText={'Jan'}>}Amount) - this gets the data for the month of Jan
condition is: 
=count({<Month={"<=$(vMonth)"}, MonthText={'Jan'}>}MonthText)

[paulwalker]

Is there any better approach instead of hardcoded for all months ??

[edwin]

Build a bridge table between your fact and the calendar. Create pseudo values for perio mint current month then January to December 

then pivot the new field