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 im want to know if is possible get soem values summarized after certain time for example i want to know the qty of sites after 2022 all this in the chart
like in here instead of put any value after year 2022 shows the count of everything after that
Solved! Go to Solution.
Hi @szielinski
You can do a couple of things. One quick way is to create a Calculated Column like below:
Then in the Fields pane (far right of screen), click the "Year" column and the "..." button. Go to "New Group" then in Group Type change "Bin" to "List". From the list, select the historical and current year (i.e. 2019 to 2021) and use the "Other" group to include "ungrouped values". Click Okay.
You can now use the "Year (groups)" field for your X axis.
Hope this helps 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Hi @szielinski
You can do a couple of things. One quick way is to create a Calculated Column like below:
Then in the Fields pane (far right of screen), click the "Year" column and the "..." button. Go to "New Group" then in Group Type change "Bin" to "List". From the list, select the historical and current year (i.e. 2019 to 2021) and use the "Other" group to include "ungrouped values". Click Okay.
You can now use the "Year (groups)" field for your X axis.
Hope this helps 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
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 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |