topic Re: How to access a graph table ( used to create a graph ) , so I can calculate a histogram in DAX Commands and Tips

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

Anonymous — Mon, 02 Dec 2024 01:09:29 GMT

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.

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

lbendlin — Mon, 02 Dec 2024 01:58:29 GMT

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

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

Anonymous — Mon, 02 Dec 2024 02:07:32 GMT

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

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

FreemanZ — Mon, 02 Dec 2024 09:59:08 GMT

hi Anonymous ,

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.

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

Anonymous — Mon, 02 Dec 2024 12:04:41 GMT

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.