visualization

  1. S

    Extract the values from a table based on a rule and create a new table

    Hi I am quite new to power bi and trying to learn how to use DAX and other power bi queries. I have been trying but not able to get what I want from my below query. I hope someone can help. I have same data in below 2 formats and I want the output table as below. Any data table can be used to...
  2. D

    Tableau for Data Visualization Software

    I'm thinking about software to help with graphics. Has anyone used Tableau, or one of the other data visualization tools? What are your impressions and how is the cost? Thank you - Dave
  3. P

    Sparklines - zoom/pop out

    Hi Not sure if its possible but I am looking for a way to have some sort of visualization to be able to zoom in on a selected sparkline or have it pop out Thanks
  4. kpasa

    Preferred Method to aggregate daily data

    Hello Community! I'd like to get your thoughts on how I should approach a new project. We get a daily report from one of our partners with subscriber usage stats. It comes in the form of a CSV and is only 1 day's worth of data. Our goal is to aggregate the data in order to do calculations on...
  5. M

    Copy paste charts with dynamic rows/column references

    Hey guys, Not sure if I neeed VBA to accomplish this or not, but I can’t be the first that needs a way to do this. I have a column of dates in A. In column B I am computing the AVERAGE of the values in columns C through Z). And then in columns C through Z I have data. I would like an easy way...
  6. T

    Creating a table from a table visualization

    Hello, I have a table visualization that has a few columns based on DAX measures. It has 500K records. I would like to export it to a CSV and would be happy to use the DAX studio. But...How do I "convert" the table visualization into a "regular" table to which I could query in the DAX...
  7. A

    Power BI Table Visualization NaN and Numbers in same column

    Hi everyone, I have an Excel Table several columns that contain numbers but a few cells contain "N/A". When I load this table into Power BI and add these columns in a Table Visualization, the cells with "N/A" are blank. I am curious to know if it is possible to have "NaN" or "N/A" and Numbers...
  8. J

    Data Visualization Issue - Misaligned on X Axis

    Hi All, I attempted to post an attachment, but it appears I do not have this permission? I am attempting to fill the are under my XY scatter plot, but for some reason the area chart and XY scatter plot are just slightly misaligned along the X Axis. If anyone is willing to attempt to recreate...
  9. J

    Rotate Area Chart (Toggle X Y Axis) - Visulize a Funnel

    I've been looking for a solution to this interesting dilemma and I can't come up with a great solution... all I need to do is rotate my area chart... it's time that I opened up my question on MrExcel as I am truly out of ideas. Hoping one of you can help me solve this. I would appreciate any...
  10. A

    Matrix visualization not printing colors

    Hi all, I published the PowerBI Desktop to web to print my reports in PDF. But for the matrix visualization the print option does not show/print the color not in PDF nor printing with real printer. I tried the printer settings but did not work :-( Any solution?
  11. J

    Making min-max-average bar charts work

    Hello everybody, I'm trying to recreate this graphical representation for my data, which is an aggregation that consists of many series each with three columns: min, max, and average in the range from 1.0 to 4.0. I've experimented with floating bar charts, where I've created a fourth column...
  12. L

    Excel - Bar Chart with horizontal reference line on each bar

    want to create a bar chart that compares groups at 2 points in time, t1 vs t2. But instead of having them side by side, I want to have t2(now) as a bar and t1(before) as a horizontal line. Similar to what you can do with Tableau (for those who use it). Except it does not have to be Horizontal...
  13. S

    How to visualise the costs per unit of several energy providers?

    Hello, energy providers usually charge a monthly fixed rate and a flexible consumption-based rate. Some only charge the later. This has implications for the overall costs based on projected consumption. I want to enter the the fixed and flexible rate into excel and then get a graph that show...
  14. N

    Bubble Visualization of 'Excel Questions'

    Here is a quick bubble pack layout of this sub-forum Bubble My Page Visualization - http://www.mrexcel.com/forum/excel-questions/ - using D3js.org You can generate such bubble visualization for any tabular data including excel or flat files. -NJ
  15. A

    Simple visualization for project database

    Hi everyone, I have a request that should hopefully be somewhat simple for the geniuses out there. I've played with variations of arrays, INDEX, and MATCH, but can't figure this one out. This is how my database is stored: <table x:str="" style="border-collapse: collapse; width: 276pt;"...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top