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 have a table that has 2 colums the first is years from 2012 to 2017 and the second in about two products i need to create a graph that will allow me to show for each year which were the sales for each product, im been trying to use the clustered columb chart but the problem is that it shows me the total of the sales of the products in all of the years not the total of each product per year.
hope you can help me
Solved! Go to Solution.
Hey,
sorry for the late response, but as far I understand your requirement this might be solve your requirement without any DAX magic involved 🙂
Here is a screenshot of a very simplistic datamodel, just containing two columns, year and product
I put the year column to the Axis pane (from the format of the xaxis i set the type to categorical), put the product to the legend pane and also ont the value pane (due to the text datatype of the column the aggregation COUNT is chosen).
You might wonder about the numbers that are shown in chart, this is simply due to the fact of the underlying base table shown here
Hopefully this is what you are looking for, from my point of understanding, there is no need to work with Quick measures for this requirement
Regards
Tom
Hi @anaorca1990,
Have you solved your problem with the solutions provided by @lisaeugene and @TomMartens?
If you have solved your problem, Please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share some data sample and expected output, so that we can help further investigate on it?
Best regards,
Cherry
How about a stacked bar chart showing a bar for each year, segmented by product sales? To do that you need to choose that chart from your visualizations board. The fields you can use to come up with the sample one below are:
You mentioned that you have only two columns in your table, but for my example here you need three. Sounds like you have the first two columns I mentioned, but need to have the sales amounts for the products in a third column in order to produce this kind of visualization.
Hope this helps!
hello
i have a problem cause they are only in two rows so this wont work, but thank you for help
Hello,
the problem is there arent any numbers, everytime a name product shows is the list it equals one sale, i dont know if this makes it easier to understand
Hey,
sorry for the late response, but as far I understand your requirement this might be solve your requirement without any DAX magic involved 🙂
Here is a screenshot of a very simplistic datamodel, just containing two columns, year and product
I put the year column to the Axis pane (from the format of the xaxis i set the type to categorical), put the product to the legend pane and also ont the value pane (due to the text datatype of the column the aggregation COUNT is chosen).
You might wonder about the numbers that are shown in chart, this is simply due to the fact of the underlying base table shown here
Hopefully this is what you are looking for, from my point of understanding, there is no need to work with Quick measures for this requirement
Regards
Tom
I also struggled alot with the similar problem.Thanks alot this really helped
thank you so much for your patience, and your help.
Hi there,
Based on how I understand what you're trying to accomplish, your quick measure might be the fastest and best way to accomplish your visualization, given how your data's put together. There are many ways to build measures to count the Tipo de Contratos for a given year, but none of them are as simple or as fast as a quick measure. So, I'd stick with that for the time being.
That's my best answer for this situation. Hope it helps / Lisa
Hello,
the problem is there arent any numbers, everytime a name product shows is the list it equals one sale, i dont know if this makes it easier to understand
Hey,
give the infographic desiger from the marketplace a try:
Here is a screenshot:
I also changed the type to bar:
But maybe the default bar chart will also work
using the format option
Hopefully this gives you some ideas
Regards
Tom
hi Tom, thanks for you reply the problem is that only have two colums one with the year and the other with kind of th product, im attaching a pic, sorry is in spanish.
the first row is the years and the other one that is highlight is the product
i manage to find a solution using a quick measure but i want to know if there is an easier way. what it does is that it counts how many items were sold by category per year
hope im clear, thank you for your help
hi Tom, thanks for you reply the problem is that only have two colums one with the year and the other with kind of th product, im attaching a pic, sorry is in spanish.
the first row is the years and the other one that is highlight is the product
i manage to find a solution using a quick measure but i want to know if there is an easier way. what it does is that it counts how many items were sold by category per year
hope im clear, thank you for your help
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |