Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello !!
A simple question but i can't find answer on the forum.
I have a table where i have table with in columns : ID, review name and a number. (See below)
What i wnat to do is a dynamic comparison between reviews. Thus to dothat i want i slicer wich filter all the table + a slicer wich permit me to import the number of the second review selected.
Like that i will have for exemple if i selected review 1 i have all the data of review 1 and in the second slicer if i selected review 3 i import via the mesure just the column which is the number :
and the objective is to compare so if i can import the data of the second slicer in a column, i can do the soustraction.
the question is : Can i import in a new column via a mesure all the value filtered by the second slicer on power bi ?
Thanks by advance for your help,
Florian
Solved! Go to Solution.
Hi @Anonymous
You need to create 2 tables with reviews ( 1 for every slicer).
I created them with PQ, duplicated the table, removed unneeded columns and removed duplicates :
and duplicated again a resulted table because we need 2.
The next step is to create a relationship between those tables and your fact table :
The values of those 2 tables is for the 2 wanted slicers :
The next step is to create 2 measures :
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @Anonymous
You need to create 2 tables with reviews ( 1 for every slicer).
I created them with PQ, duplicated the table, removed unneeded columns and removed duplicates :
and duplicated again a resulted table because we need 2.
The next step is to create a relationship between those tables and your fact table :
The values of those 2 tables is for the 2 wanted slicers :
The next step is to create 2 measures :
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
HI there !
Super, many thanks for your help ! I didn't think to display all my data with measure which is much more easier ! super !!! 🙂
Have a good day,
Happy to help 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
78 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
61 | |
60 |