Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Visualizing Measures in Power BI Without Additional Tables

Hi all 

I am working with a Power BI report that contains a table where all cells are populated by measures instead of direct table values. I want to display this data to users without the need to create a new physical table.

Here's an example of what the datatable might look like:

Sales KPI = DATATABLE("Name", STRING, "Order", INTEGER, {{"Sales Branch 1", 1}, ...})

For each column, I will have a measure that can identify the order from the initial table and display the corresponding measure, such as:

Sales This Year =
VAR salesOrder = SELECTEDVALUE('Sales KPI'[Order], 1)
RETURN
SWITCH(salesOrder,
1, [M1],
2, [M7],
...)

I am seeking a visual that can accomplish this structure.
Is there a way to visualize these measures dynamically without creating new tables?
Can this be done using a Bullet chart by OKVIZ, ZEBRA BI Table, or any other custom visual in Power BI?

Any suggestions or guidance from the community would be greatly appreciated.
Thank you in advance.

 






2 Replies

  • Anonymous 

    I didn't quite understand your question and what you are up to. However, have you explored the possiblity using the Field Parameters ?

    • Anonymous's avatar
      Anonymous
      Not applicable

      Sorry for this , it seems that I forgot to add a picture 🙂