Forum Discussion
Scaling Numbers within Power BI
Hello Power BI Community, I am working on a project that requires scaling of data within Power BI. Attached is an example file with a small dataset. The dataset I am using is much larger and more...
So as an update to my earlier post,
- I figured out why the GenerateSeries() wasn't working properly. All I needed to do was set it to a fixed decimal value and it worked fine even with the higher number range.
- I was using a lot of IF statements to create the options I needed, but I found that Switch() can be used to clean that up a lot.
- I am still using a lot of tables (now they are all GenerateSeries() instead of hard coded tables) for the number selections by the users so if anyone knows of a better way of doing that I would appreciate the help.