Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Activate calculation/measure in visual table by toggle button/bookmark/slicer etc.

Hi PowerBi community,   I created a visual table with 2 slicers.  The effort in last column of visual table is displayd in hours from a database. Now I want to switch from hours to man days....
Need Help
  • DataInsights's avatar
    DataInsights
    3 years ago

    Anonymous,

     

    You could try posting in the Report Server forum:

     

    https://community.powerbi.com/t5/Report-Server/bd-p/ReportServer 

     

    If calculation groups are available in Report Server, you could create a calculation group with two calculation items: one for Hours, and one for Man Days. Alternatively, you could create a disconnected table with two rows (one for Hours, and one for Man Days) and use DAX to display the selected value.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Super User,

 

Thanks for the fast reply, unfortunately the feature Modeling tab and select New parameter > Fields.

is not supported by Power BI Report Server. 

 

 

Do you have another suggestion?

 

Best

 

Nici

 

DataInsights's avatar
DataInsights
Super User
3 years ago

Anonymous,

 

You could try posting in the Report Server forum:

 

https://community.powerbi.com/t5/Report-Server/bd-p/ReportServer 

 

If calculation groups are available in Report Server, you could create a calculation group with two calculation items: one for Hours, and one for Man Days. Alternatively, you could create a disconnected table with two rows (one for Hours, and one for Man Days) and use DAX to display the selected value.