Forum Discussion

nicocgn's avatar
nicocgn
New Member
3 years ago

Graph do not work with measures made with SWITCH function

Hello, I am creating a Financial Statement from zero in PBI where I have a "Profit and Loss" table with just the name of items (like Sales, Cost, earning...) and for each line item I have created a Measure for calculating the amount.

I can build a visualization "Table" where I can associate each line item to the relative measure thanks to an additional measure built with DAX function "Switch". However, the problem arise when I want to create a Line Bar chrart beacuse seems I cannot use the measue and the Profit and loss structure as I have done for the Table. Why is that? 

 

Maybe, should I create an additional Table on PBI composed by two column: one of the Profit and Loss Structure and the other one withe the measure created? How it can be done?

 

thank you