Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
Is it possible to have the visual always to show 2019 regardless of filter Selection?
Solved! Go to Solution.
Hi @carlol ,
Please try to change the type of X-axis from continuous to categorical, it should work.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @carlol ,
You can create a seprate year table and create this measure:
Year = DISTINCT('Table'[Year])
Measure =
IF (
SELECTEDVALUE ( 'Table'[Year] ) = 2019,
SUM ( 'Table'[Value] ),
IF (
SELECTEDVALUE ( 'Table'[Year] ) IN DISTINCT ( 'Year'[Year] ),
SUM ( 'Table'[Value] )
)
)
Attached a sample file in the below that you can refer, hopes to help you.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thanks
But that is not what I want
If a User Selects 2009 in the Slicer , I want to illustrate 2009 and 2010 Data Only
If a User Selects 2008 in the Slicer , I want to illustrate 2008 and 2010 Data Only
Ideally the Year table should be
Year =
Union(ALLSELECTED('Year'[Year]),ROW("Year","2010")) but based on SELECTEDVALUE ('Year'[Year])
This Should work
Hi @carlol ,
"If a User Selects 2009 in the Slicer , I want to illustrate 2009 and 2010 Data Only
If a User Selects 2008 in the Slicer , I want to illustrate 2008 and 2010 Data Only"
In the sample, you can set the slicer selection as single in the selction controls to only selcet one year value.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
If a User Selects 2016 in the Slicer , it illustrates 2016,2017,2018,2019
If a User Selects 2017 in the Slicer , it illustrates 2017,2018,2019
If as user selects 2016 , you cannot have 2017 illustrating zero , if a user selects 2017 , 20 is illustrated
The X axis needs to just illustrate the data points Selected ,
If a User Selects 2016 in the Slicer ,
2016 and 2019 is only illustrated
If a User Selects 2017 in the Slicer ,
2017 and 2019 is only illustrated
Hi @carlol ,
Please try to change the type of X-axis from continuous to categorical, it should work.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Yingjie Li, was not aware of that feature
@carlol ,
Better to have separate Year table for this
measure =
var _Sel = union(allselected(Year[Year]),row("Year",2009))
return
calculate([measure] , filter(all(Year), Year[Year] in _sel))
Few Attempts , struggling
I want it to include the filter selection and 9999
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |