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

[Ramar Veerasamy]

I want to display 14 currency in normal slicer. But it’s not displaying. If am adding report with currency & total amount measure in the same page values available for all 14 currencies and custom chiclet slicer also shows all 14 currencies. i don’t know why my slicer not displaying all the currency. 

——————————
Ramar Veerasamy
Associates Reports Developer

——————————

[krishnareddy K]

Hello Ramar,

could you please check whether you have any other filters/slicers applied in the report ,i would like to suggest you please remove any other slicers and if your currency is data coming from source just load data and use slicer for only currency and see if you can able to see all currency values in the slicer or not ,if you still face the same issue ,would like to suggest you to import custom slicer form market like hierarchy slicer and see if you can able to see the currency values are not .make sure what kind of data type used for the currency filed.

——————————
krishnareddy K
Sr Software Engineer.
——————————
——————————————-

[Ramar Veerasamy]

Thanks @krishnareddy K,  I have 21 company & excluded ?1 company name from page level.? Values are available for 20 company & 14 currency. i refreshed with page level filter it’s not displaying all currency..with the same in data model i am changing one connection from Bi directional to single direction.. Normal slicer also displaying all the currency. i don’t want to change from Bi directional to single. Because this data model common for other reports.. What should i do?

Note: Marked blue color’s are using for report preparation.

——————————
Ramar Veerasamy
Associates Reports Developer
7708177403
——————————
——————————————-

[krishnareddy K]

Hello,

If you don’t want to use single direction, I can suggest that you can create temporary table by adding company and currency values in power bi desktop manually other then datasource. After connection created under fields with company and currency you can map company filed with other table company filed and use currency value in slicer may work.

——————————
krishnareddy K
Sr Software Engineer.
——————————
——————————————-