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, yy dashboard has two slicers - Date and Hierarchy 1. the previuos month card only changes with Date slicer but not respond to Hierarchy 1 slicer. For example, if I select Hierarchy 1 “B”, the previous month should be 13, but it still shows the whole month. Can you help on this?
Please see the attched samples:
Sample Raw Data - Previous Month.xlsx
Many Thanks,
Mei
Solved! Go to Solution.
Hi,
here the link to dowload the pbix file with the solution
https://we.tl/t-eCvpd8GzDQ
I create a date table that helps you to understand why you were wrong.
A table near the result explain the solution of the counting.
The relation beetween the two tables must be BOTH (in every direction -> and <-).
I hope i help you.
PLEASE MARK AS A SOLUTION IF I RESOLVE YOUR PROBLEM
Regards
Luca D'Elicio
Hi,
here the link to dowload the pbix file with the solution
https://we.tl/t-eCvpd8GzDQ
I create a date table that helps you to understand why you were wrong.
A table near the result explain the solution of the counting.
The relation beetween the two tables must be BOTH (in every direction -> and <-).
I hope i help you.
PLEASE MARK AS A SOLUTION IF I RESOLVE YOUR PROBLEM
Regards
Luca D'Elicio
Hi Luca,
Thanks so much to looking into my question! the link you provided is not the pbix link. Can you please share it again?
Thanks,
Mei
Look better please!
here the link to dowload the pbix file with the solution
https://we.tl/t-eCvpd8GzDQ
Great! you are amazing, Luca! I accepted it as a solution.
One more thing - how can I copy the Datatable you created within pbix to my new pbix?
Thanks,
Mei
Hi,
thank you, if you go in the datatable mode view you can select the table and copy the dax code that i used to create it.
When you paste it in your project select "Create new table" in the menu and replace every reference to the old table with the new table.
Try to understand what the code does it's not difficult.
It will be more easy replace the value!
Regards,
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |