I have a data table where there are a number of metrics. Each metric has its min, max, target, value in the columns. If I want to create a gauge for each metric, looks like I have to put the data of each metric in its own table, rather than all in one data table. In other words, if I have 10 such metrics, I have to split them into 10 tables on 10 different work sheets in Excel, and import them into Power BI as 10 tables. Do you think there is any efficient way of doing this? Thanks a lot.

I found the solution. I don't have to split the data into N data sheets. I can just import the original data file and for each gauge, I use filter to get to each metric.

without looking at the data source it is hard for me to imagine the scenarios you have described. But this is what I would do - create a custom column that will separate each metric for example apples then we have min, max and target value for apples, then we have oranges - min max and target value and etc. Then we simply put a filter on each gauge visual - one for apple, another one for oranges and this is how you can do this by using one data table instead of 10. I hope this helps