Forum Discussion
visualization
- 8 years ago
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
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