How to access a graph table ( used to create a graph ) , so I can calculate a histogram

[wokka]

Hi,

I build a lot of one-off/ad hoc graphs regularly, but now need to perform calulations on the graph to produce histogram info about the graph data.

I normally firstly manually create a table, then manually convert the table to the type of graph I need.

My question is how can I save the original table we used to create the graph, into something like a temporary table ( like you would in SQL Server ) , then maybe dump this into a permanent custom table ( maybe this is created via power query / DAX ?? ) to allow me to create histogram buckets and apply it to the temporary table, and then create a histogram?

If I can do this, it opens up a huge useful capability for us. 

Thank you in advance. 

[lbendlin]

Sounds like you are looking for the LOB functionality of Tableau?  Dynamic bucketing is not something Power BI supports at the moment.

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com

[wokka]

Hi

So is it possible to save the table that I use to produce the graph, somehow using power query or some other method ?

[FreemanZ]

hi @wokka ,

visual table could be obtained as calculated table with functions like SUMMARIZECOLUMNS().

you can save the DAX query with SUMMARIZECOLUMNS() code in the pbix file or as text file.

[wokka]

Hi

I'm still newish to powerbi, do you hve any code I might be able to adapt that uses SUMMARIZECOLUMNS() please?

Despite having in DBA background, I find the DAX at the moment, a little confusing at times and knowing when to use which functions etc , can be challenging....

Thanks in advance.