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.
Hello,
I need some help on this topic.
I have a selected value in the slicer month (8). In the visual I want to show all the month from 1 to 8. What is the best way to show all the data per month in the visual?
Solved! Go to Solution.
Hi @Anonymous ,
You can create a new measure to judge if the month meets the criteria and use filter to display correct months.
Here is my test file, you can download and refer to it.
Hi @Anonymous ,
You can create a new measure to judge if the month meets the criteria and use filter to display correct months.
Here is my test file, you can download and refer to it.
Hi,
You may refer to my solution here - Flex a Pivot Table to show data for x months ended a certain user defined month.
Hope this helps.
Thanks but I need a solution for PowerBI in Dax
You are welcome. Open PowerBI desktop and go to File > Import > Excel. This will bring over all Tables, relationships and measures in PowerBI desktop.
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 |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |