Hello all, I need help in representing multiple measures in sunburst chart to show the hierarchy. I have a table with category and subcategories. But the values are calculated using measures , not in calculated column,as I have to use what if parameter inputs for calculation.Each measure is calculated using different formula. Now I’m not able to bring those values in visual . Is there any way I can represent these values in a sunburst or any similar visual? Is it possible to manually assign values to category? Any help will be appreciated! Thanks!
Thanks!I could do it by creating an index column in the table and then created a measure using switch function which uses selected value of index and display the corresponding measure. Visual value=switch(true(), selectedvalue(table(index))=1,measure1...)