Forum Discussion

Tsanka's avatar
Tsanka
Kudo Collector
10 years ago
Solved

KPI Preview Feature - SSAS Tabular

Hi   The blog information about the October update of PowerBI desktop states that KPI preview visualization is supported from PowerPivot or SSAS tabular.   I created a simple KPI in my tabular an...
Need Help
  • atul_kushwaha's avatar
    atul_kushwaha
    10 years ago

    I managed to resolve this issue.

     

    Issue was witrh compatability mode of SSAS Tabular Model. I set it to "SQL Server 2014 / SQL Server 2012 SP1 (1103):" and defgined KPI started showing in both Power BI Desktopp & Power view.

     

    Hope it will hep others those may face similar problem.

     

     

    Atul,

Tsanka's avatar
Tsanka
Kudo Collector
10 years ago

Thanks for the quick reply.

 

I did try. Attached is a screenshot. The PowerBI desktop was restarted after enabling the preview feature. The status shows just values -1, 0 and 1 for the 3 KPI states.

 

KPI.png

 

PS: Just adding the part of the script that adds the 3 measures. May be I have added them incorrectly?

 

      #"Added Items" = Cube.Transform(MyCube, {{Cube.AddAndExpandDimensionColumn, 
    .....

 

        {Cube.AddMeasureColumn, "Value", "[Measures].[MarginKPI]"},
        {Cube.AddMeasureColumn, "Goal", "[Measures].[_MarginKPI Goal]"},
        {Cube.AddMeasureColumn, "Status", "[Measures].[_MarginKPI Status]"}}
        )

meysun's avatar
meysun
Resolver IV
10 years ago

The upcoming November update should fix this. Once it's available ( very soon :), please give it a try and if the issue still repros, let us know.