Best practice in report building with SSAS Olap Cube Connection

[AP_BI]

Hello together, 

I have a general question on building dashboards from OLAP cube dataset. I consume data from a big cube connection where each KPI does not have its own datafield but is stored in "KPI". To use a specific KPI for a visual, I select the required KPI in the filter pane which is working fine if I only need one information (e.g. bar chart or line chart). 

Visualising capabilities are very limited if I want to display more than one KPI. In this case I am forced to show in a Table or Matrix chart. 

My question: Is there any solution or "best practice" in handling cube datasources having splitted KPI Name and Value fields? As it is SSAS Live Connection I am also not able to add Measures (which could act as workaround)

Would be very grateful for any help!
Andreas

[v-easonf-msft]

Hi, @AP_BI 

There are many limitations of SSAS live connection, but this is also the reason why SSAS models are highly secure.

Currently you cannot create measures in Power BI Live Connection, but you can add them in your original SSAS model.

Related tutorials:

Measures in tabular models 

Video_Report level measures with Power BI live connections 

Video_Measures and Measure Groups on SSAS Tabular Models 

Best Regards,
Community Support Team _ Eason

[AP_BI]

Hello @v-easonf-msft ,

thank you for your response regarding SSAS Measure creating answer. Could you respond on the first part of the question? 

I am looking for best practice in handling that mentioned SSAS case if quantitative value field and KPI name are splitted fields (I described my handling into detail in my previous post)

Thank you
Andreas