Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
Im my report, i need to filter the year selected in slicer and year -1. Its something like this:
SELECT RETURN
2018 2018
2017
2017 2017
2016
2016 2016
2015
2015 2015
2014
My table is created based in SUMMARIZECOLUMNS , and have a column with year. Someone have any solution to this?
Solved! Go to Solution.
Hi@ guilherme_gq
You can use UNION() and DISTINCT() function to create an intermediate table like below:
intermediate Table = DISTINCT(UNION(VALUES('Table'[year]),VALUES('YEAR TABLE'[return])))
And create relationship between two table by the intermediate table
Then drag filed into slicer
For example ,when we select 2018 it return 2018 and 2017
Best Regards,
Lin
Hi@ guilherme_gq
You can use UNION() and DISTINCT() function to create an intermediate table like below:
intermediate Table = DISTINCT(UNION(VALUES('Table'[year]),VALUES('YEAR TABLE'[return])))
And create relationship between two table by the intermediate table
Then drag filed into slicer
For example ,when we select 2018 it return 2018 and 2017
Best Regards,
Lin
Good job, Lin! Thanks for your help!
@guilherme_gq To get both years you could use SELECTEDVALUE(year) and SELECTEDVALUE(year)-1 to get both the years. If this doesn't answer your question I need more details on the setup to be able to better answer the question.
Mnayar,
I create a table like the first post. But im trying to filtering based in relationship with two tables. For example:
YEAR TABLE
SELECT RETURN
2018 2018
2018 2017
2017 2017
2017 2016
2016 2016
2016 2015
2015 2015
2015 2014
But when i try to create relationship between the new table and the table with each row of sell, i recieve this message:
"You Can´t create a relationship between these two columns because one of the columns must have unique values."
create a date dimention and hook these 2 tables to that date dimension.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |