Hi All,
Need help to fix this. If i select Sales radio button the measure name should show only 2 line items Item 1 sold and Item 2 sold. And similarly if i select Transaction radio button it should show count Item 1 and Count Item 2.
You may benefit from unpivoting [Count Item 1], [Count Item 2], [Item 1 Sold] and [Item 2 Sold]. That would allow you to select which measures you want displayed in the donut chart using a filter on a simple calculated field.
Hey Stephen, The data is not in excel format and i know that unpiviot will work only with excel data source. And also there is no boolean value in data source. It is connected with parameters.