Forum Discussion

anaorca1990's avatar
anaorca1990
Helper I
8 years ago
Solved

visualization

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 sale...
  • TomMartens's avatar
    TomMartens
    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