Forum Discussion
Infographic Designer - multiple measures
Dealing with the same problem and really hoping someone from Microsoft can post a solution.
If you use the Legend by Measure option, this allows you to have multuple columns (or rows) with one measure per row, but they must all be the same icon. Kind of defeats the purpose of having an infographic tool in the first place.
My workaround was to create a summary table where, in one column, every row was the category name, and in another column, every row was the value that category should have. However, this solution is not dynamic, as the calculated table is preprocessed: https://community.powerbi.com/t5/Desktop/how-to-create-table-Summarizecolumns-keep-filter-context/m-p/295462
Adding statements that would force the DAX expression to recalculate continuously (ex. 'NOW') doesn't solve the problem.
So after spending a day on this, I'm back to square one.
Don't know if acbg , khicks , or others are still looking for an answer, but after some experimentation, I found a solution.
If someone is having this problem, reply and I'll post something more detailed with examples, but the simple-ish summary is:
- Create a new table where the number of rows is equal or greater to the number of measures you want to put in your infographic, and the first value is the row number.
- Create a new column in this table with the names of your measures by row (ex. if row = 1, name = measure 1, etc.)
- Create a measure whose value changes based on the sum of the row column (ex. if row = 1, expression for measure 1, etc.). In my case, I used a SUMX expression to ensure the value will always be calculated for each filtered row in the dataset.
- In the infographic, put the column with your measure names in the "category" field and your measure from step 3 in the "measure" field.
- Manipulate the infographic editor as you would normally.