Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Yogabalakrishnan Kannan]

Hi Friends,
I had an issue when I add a new measure. Trying to understand best ways to have a fixed base and proceed with enhancements without breaking existing functionalities.

When I add below measure, It brought more number of rows with all empty values in the matrix.

Proj Growth Indicator old = switch(true(),[Projected %]<0,UNICHAR(9940),[Projected %]<1,UNICHAR(9660),[Projected %]>1,UNICHAR(9650),BLANK())

Then I add condition like this, I got correct number of rows. (This need to be better written)

Proj Growth Indicator = if(not(ISBLANK([Projected %])),if([Projected %]<1,unichar(9660)))

Just need to have an indicator for existing data.

My understanding on this, when we do any changes (add/remove), the underlying query generated for the visual changes completely as per current fields/measures. 

Note:
We have model file and Report file (that refers the model) separately. We finalize all columns and Measures in model. Yet not allow the user to create new report from Model.and will be done near future.

Questions:
1. Without measure, how can I add this indicator in a new column in matrix. (Not just using conditional setting in the Projected % itself, to show the font in red/Green). Want a icon like this on separate column.
2. Once my model is fixed, if i don’t have access to change the model, as a developer how can I do this? (Other than, create new measure in report) 
2.1. In case of measure creating in report file is ok or add to model? which will be best to follow and what scenarios?
3. If end user wants to do this, how can we provide a Model and report in such a way that, this issue will not happen. 

Thanks,
Yoga

——————————
Yogabalakrishnan Kannan
——————————

[Neville Howard]

Hi 

To answer some of your questions in simple terms… 

PBI Desktop is the only place you can import data, create a data model, and create Measures.  If new measures are needed, add to the original PBI file and re-publish.

PBI Desktop and PBI Service can be used to create Report Pages. 

PBI Service is the only place you can share PBI reports.  This sharing is mostly on a read only basis.  If you give them edit rights (via a workspace), they can only add visuals and pages. 

regards,

——————————
Neville Howard
Consultant
Brisbane
0732228400
——————————
——————————————-