Forum Discussion
Field Parameter appear as count
- 11 months ago
It's solved FP Don't work with mixed storage
Live only working fine
Thank you all
Hi ahmedshalabyy12 ,
this is most likely due to field parameters not being supported with a live connection to a semantic model (SSAS/Analysis Services). When you use a live connection, Power BI can’t evaluate the dynamic field parameter the same way as in an imported dataset, so the visual ends up showing a default aggregation like Count.
What you can try or consider:
If possible, switch to an imported Power BI dataset (or publish a Power BI dataset) instead of using a live SSAS connection. Field parameters work in that scenario.
If you must stay with a live semantic model, field parameters are not reliable for dynamic measure switching. In that case you have two workarounds:
Implement the dynamic measure logic on the server side (in the semantic model) using pre-defined measures and a slicer (DISCONNECTED parameter table) that maps to those measures. Note: this requires you to modify the semantic model itself.
Use separate measures in the report (Sum, Avg, Count) and provide a manual way to switch visuals via bookmarks or a slicer, but this won’t be a true field parameter switch in real-time.
Check the datatype of the field parameter column in the semantic model. A mismatch (e.g., numeric vs text) can cause odd behavior. If you can, ensure the parameter column is a text/string type and that the parameter table is properly designed for a field parameter.
Please mark this post as solution if it helps you. Appreciate Kudos.
I just test another field parameter with another live report and it's working fine